52.54. 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 52.54. pg_subscription_rel Columns

NameTypeReferencesDescription
srsubidoidpg_subscription.oidReference to subscription
srrelidoidpg_class.oidReference to relation
srsubstatechar  State code: i = initialize, d = data is being copied, s = synchronized, r = ready (normal replication)
srsublsnpg_lsn  Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null