Skip to content

`pg_subscription_rel`

pg_subscription_rel

The catalog pg_subscription_rel stores the state of each replicated table and sequence for each subscription. This is a many-to-many mapping.

This catalog contains tables and sequences known to the subscription after running: CREATE SUBSCRIPTION, ALTER SUBSCRIPTION ... REFRESH PUBLICATION, or ALTER SUBSCRIPTION ... REFRESH SEQUENCES.

Table: pg_subscription_rel Columns

Column Type

Description

srsubid oid (references pg_subscription.oid)

Reference to subscription

srrelid oid (references pg_class.oid)

Reference to table or sequence

srsubstate char

State code for the table or sequence.

State codes for tables: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)

State codes for sequences: i = initialize, r = ready

srsublsn pg_lsn

Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null