↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_replication_origin_progress

Read the PG 18 manual

Returns the replay location for the given replication origin.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

Signatures & examples

pg_replication_origin_progress ( node_name text, flush boolean ) → pg_lsn
Returns the replay location for the given replication origin. The parameter flush determines whether the corresponding local transaction will be guaranteed to have been flushed to disk or not.
Version history 3
  1. 12 → 13 changed
  2. 9.6 → 10 changed
  3. 9.4 → 9.5 added

Definition snapshot: b7bd9cda · English manual source