Functions / System Administration Functions

pg_log_standby_snapshot

Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one.

Reading PG 18current·documented in 5 of 27 versions, 16 to 20

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

Signatures & examples

pg_log_standby_snapshot () → pg_lsn

Take a snapshot of running transactions and write it to WAL, without having to wait for bgwriter or checkpointer to log one. This is useful for logical decoding on standby, as logical slot creation has to wait until such a record is replayed on the standby.

Version history 1

15 → 16 added

Definition snapshot: b7bd9cda · English manual source