51.55. pg_subscription_rel

51.55. `pg_subscription_rel`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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

Column Type Description
`srsubid` `oid` (references `pg_subscription` . `oid` ) Reference to subscription
`srrelid` `oid` (references `pg_class` . `oid` ) Reference to relation
`srsubstate` `char` State code: `i` = initialize, `d` = data is being copied, `f` = finished table copy, `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

Column Type

Description

srsubid oid (references pg_subscription . oid )

Reference to subscription

srrelid oid (references pg_class . oid )

Reference to relation

srsubstate char

State code: i = initialize, d = data is being copied, f = finished table copy, 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

Prev	Up	Next
51.54. `pg_subscription`	Home	51.56. `pg_tablespace`