Functions / System Administration Functions

pg_last_xlog_replay_location

Get last transaction log location replayed during recovery.

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_replay_location ( ) → pg_lsn

Get last transaction log location replayed during recovery. If recovery is still in progress this will increase monotonically. If recovery has completed then this value will remain static at the value of the last WAL record applied during that recovery. When the server has been started normally without recovery the function returns NULL.

Version history 3

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

Definition snapshot: b7bd9cda · English manual source