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.
|
