51.53. pg_subscription_rel

目錄 pg_subscription_rel 包含每個訂閱中每個複寫關係的狀態。這是多對多的關連情況。

在執行 CREATE SUBSCRIPTION 或 ALTER SUBSCRIPTION ... REFRESH PUBLICATION 之後才會更新，此目錄僅會包含已知的訂閱資料表。

Table 51.53. 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, 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