PostgreSQL

52.79. `pg_replication_origin_status`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.79. `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 50.

Table 52.80. pg_replication_origin_status Columns

Name Type References Description

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.

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
52.78. `pg_publication_tables`	Home	52.80. `pg_replication_slots`

52.78. pg_publication_tables

Home

52.80. pg_replication_slots

PostgreSQL

52.79. pg_replication_origin_status

52.79. `pg_replication_origin_status`