This page in other versions: 9.5 / 9.6 / current (10)  |  Development versions: devel / 11

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
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.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group