pg_subscription_rel

The catalog pg_subscription_rel contains the state for each replicated relation in each subscription.

Columns 4

Column	Type	Description / reference
`srsubid`	`oid`	Reference to subscription pg_subscription.oid
`srrelid`	`oid`	Reference to relation pg_class.oid
`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 history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`srsubid`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`srrelid`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`srsubstate`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`srsublsn`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●

Version history 3

Definition snapshot: english-manuals:6361fe0b58345b7301d2d5513c5… · English manual source