51.54. 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.54.
pg_subscription_rel
Columns
| Name | Type | References | Description |
|---|---|---|---|
srsubid
|
oid
|
|
Reference to subscription |
srrelid
|
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
|