Postgresql 中文操作指南
54.18. pg_replication_origin_status #
pg_replication_origin_status 视图包含有关对特定源的重放已进行多远的信息。有关复制源的详细信息,请参见 Chapter 50。
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 54.18. pg_replication_origin_status Columns
Table 54.18. 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. |