49.53. pg_subscription_rel
The catalogpg_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 eitherCREATE SUBSCRIPTION orALTER SUBSCRIPTION ... REFRESH PUBLICATION.
Table 49.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 ins orr states, otherwise null |