PG_SUBSCRIPTION_REL
The system catalog PG_SUBSCRIPTION_REL contains the status of each replicated table in each subscription. It is a many-to-many mapping.
This system catalog contains only tables known to the subscription after running CREATE SUBSCRIPTION or ALTER SUBSCRIPTION… REFRESH PUBLICATION.
Table 1 PG_SUBSCRIPTION_REL columns
Name | Type | Description |
|---|
srsubid | oid | Identifier of the subscription. |
srrelid | oid | Subscription relationship ID. |
srsubstate | char | Subscription status. i: Initialization.d: Basic data being replicated.f: Basic data replication completed.s: Progress synchronized with incremental replication.r: Incremental replication ready. |
srcsn | int8 | Snapshot CSN during basic data replication. |
srsublsn | text | Remote LSN used to synchronize the incremental replication progress in the s or r state. Otherwise, the value is null. |
openGauss 2025-10-31 07:42:18