Movatterモバイル変換

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

51.55. `pg_subscription_rel`#

The catalogpg_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 eitherCREATE SUBSCRIPTION orALTER SUBSCRIPTION ... REFRESH PUBLICATION.

Table 51.55. pg_subscription_rel Columns

Column Type Description
`srsubidoid` (references`pg_subscription`.`oid`) Reference to subscription
`srrelidoid` (references`pg_class`.`oid`) Reference to relation
`srsubstatechar` State code:`i` = initialize,`d` = data is being copied,`f` = finished table copy,`s` = synchronized,`r` = ready (normal replication)
`srsublsnpg_lsn` Remote LSN of the state change used for synchronization coordination when in`s` or`r` states, otherwise null

Column Type

Description

srsubidoid (referencespg_subscription.oid)

Reference to subscription

srrelidoid (referencespg_class.oid)

Reference to relation

srsubstatechar

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

srsublsnpg_lsn

Remote LSN of the state change used for synchronization coordination when ins orr states, otherwise null

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