Postgresql 中文操作指南

53.55. pg_subscription_rel #

目录 pg_subscription_rel 包含每个订阅中每个复制关系的状态。这是一个多对多映射。

The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.

此目录只包含在运行 CREATE SUBSCRIPTION 或 ALTER SUBSCRIPTION …​ REFRESH PUBLICATION 后订阅知道的表。

This catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION …​ REFRESH PUBLICATION.

Table 53.55. pg_subscription_rel Columns

Table 53.55. pg_subscription_rel Columns

Column Type

Description

srsubid oid (references pg_subscription.oid)

Reference to subscription

srrelid oid (references pg_class.oid)

Reference to relation

srsubstate char

State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)

srsublsn pg_lsn

Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null