PostgreSQL

PostgreSQL Elephant Logo

51.80. pg_replication_origin_status

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins see Chapter 49.

Table 51.81. pg_replication_origin_status Columns

Name Type References Description

local_id

Oid

pg_replication_origin.roident

internal node identifier

external_id

text

pg_replication_origin.roname

external node identifier

remote_lsn

pg_lsn

The origin node’s LSN up to which data has been replicated.

local_lsn

pg_lsn

This node’s LSN at which remote_lsn has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits.

 
+
Prev Up Next

51.79. pg_publication_tables

Home

51.81. pg_replication_slots

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2023 The PostgreSQL Global Development Group