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 |
|---|---|---|---|
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 |
End LSN for s and r states. |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/10/catalog-pg-subscription-rel.html