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 | End LSN for s and r states.
|