FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_last_xlog_receive_location

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

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 3

PG 9.6 → 10removed
PG 9.3 → 9.4changed
PG 9.0 → 9.1changed

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source