Movatterモバイル変換

50.79. `pg_replication_origin_status`
Prev	Up	Chapter 50. System Catalogs	Home	Next

50.79. `pg_replication_origin_status`

Thepg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins seeChapter 48.

Table 50.80. pg_replication_origin_status Columns

Column Type Description
`local_idoid` (references`pg_replication_origin`.`roident`) internal node identifier
`external_idtext` (references`pg_replication_origin`.`roname`) external node identifier
`remote_lsnpg_lsn` The origin node's LSN up to which data has been replicated.
`local_lsnpg_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_idoid (referencespg_replication_origin.roident)

internal node identifier

external_idtext (referencespg_replication_origin.roname)

external node identifier

remote_lsnpg_lsn

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

local_lsnpg_lsn

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

Prev	Up	Next
50.78. `pg_publication_tables`	Home	50.80. `pg_replication_slots`

pdf epub

Movatterモバイル変換

50.79. pg_replication_origin_status

50.79. `pg_replication_origin_status`