Functions / System Administration Functions

pg_last_xlog_receive_location

Get last transaction log location received and synced to disk by streaming replication.

Reading PG 9.6·documented in 7 of 27 versions, 9.0 to 9.6

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Historical documentation for a PostgreSQL version that is no longer supported.

Signatures & examples

pg_last_xlog_receive_location ( ) → pg_lsn

Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.

Version history 4

9.6 → 10 removed
9.3 → 9.4 changed
9.0 → 9.1 changed
8.4 → 9.0 added

Definition snapshot: b7bd9cda · English manual source