pg_replication_origin_advance ( node_name text, lsn pg_lsn ) → voidSets replication progress for the given node to the given location. This is primarily useful for setting up the initial location, or setting a new location after configuration changes and similar. Be aware that careless use of this function can lead to inconsistently replicated data.
FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS
pg_replication_origin_advance
Read PG 18 manual ↗Sets replication progress for the given node to the given location.
Signatures & examples
Version history 3
- PG 12 → 13changed
- PG 9.6 → 10changed
- PG 9.4 → 9.5added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source