51.53. 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.
This catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION
or ALTER SUBSCRIPTION ... REFRESH PUBLICATION
.
Table 51.53. pg_subscription_rel
Columns
Name | Type | References | Description |
---|---|---|---|
srsubid | oid |
| Reference to subscription |
srrelid | 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 |