PostgreSQL

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

51.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 51.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
51.52. `pg_subscription`	Home	51.54. `pg_tablespace`

51.52. pg_subscription

Home

51.54. pg_tablespace

PostgreSQL

51.53. pg_subscription_rel

51.53. `pg_subscription_rel`