PostgreSQL

52.53. `pg_subscription_rel`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.53. `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.53. pg_subscription_rel Columns

Name Type References Description

Name	Type	References	Description
`srsubid`	`oid`	`pg_subscription.oid`	Reference to subscription
`srrelid`	`oid`	`pg_class.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 in `s` or `r` states, otherwise null

srsubid

oid

pg_subscription.oid

Reference to subscription

srrelid

oid

pg_class.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 in s or r states, otherwise null

Prev	Up	Next
52.52. `pg_subscription`	Home	52.54. `pg_tablespace`

52.52. pg_subscription

Home

52.54. pg_tablespace

PostgreSQL

52.53. pg_subscription_rel

52.53. `pg_subscription_rel`