PG_SUBSCRIPTION
PG_SUBSCRIPTION contains all existing logical replication subscriptions. This system catalog is accessible only to system administrators.
Unlike most system catalogs, PG_SUBSCRIPTION is shared across all databases in a database instance. Each database instance has only one copy, not one copy per database.
Table 1 PG_SUBSCRIPTION columns
Name
|
Type
|
Description
|
|---|
oid
|
oid
|
Row identifier (hidden attribute, which must be specified).
|
subdbid
|
oid
|
OID of the database where the subscription is located.
|
subname
|
text
|
Subscription name.
|
subowner
|
oid
|
Subscription owner.
|
subenabled
|
bool
|
If true, the subscription is enabled and should be replicated.
|
subconninfo
|
text
|
Information about the connection to the publishing database.
|
subslotname
|
text
|
Name of the replication slot in the publishing database. If this parameter is left empty, the value is NONE.
|
subsynccommit
|
text
|
Value of synchronous_commit of the subscription worker.
|
subpublications
|
text[]
|
Array containing names of the subscribed publications. These are referenced publications on the publisher server.
|
