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.