Postgres Pro Enterprise : Documentation: 14: 54.83. pg_replication_origin

54.83. `pg_replication_origin_status`
Prev	Up	Chapter 54. System Catalogs	Home	Next

54.83. `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 52.

Table 54.84. pg_replication_origin_status Columns

Column Type Description
`local_id` `oid` (references `pg_replication_origin`.`roident`) internal node identifier
`external_id` `text` (references `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.

Column Type

Description

local_id oid (references pg_replication_origin.roident)

internal node identifier

external_id text (references 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
54.82. `pg_publication_tables`	Home	54.84. `pg_replication_slots`

epub pdf

54.83. pg_replication_origin_status

54.83. `pg_replication_origin_status`