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.54. pg_subscription_rel Columns
Name | Type | References | Description |
---|---|---|---|
srsubid | oid | pg_subscription.oid | Reference to subscription |
srrelid | oid | 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
|