Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10

51.53. pg_subscription

The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 30.

Unlike most system catalogs, pg_subscription is shared across all databases of a cluster: there is only one copy of pg_subscription per cluster, not one per database.

Access to the column subconninfo is revoked from normal users, because it could contain plain-text passwords.

Table 51.53. pg_subscription Columns

Name Type References Description
oid oid   Row identifier
subdbid oid pg_database.oid OID of the database which the subscription resides in
subname name   Name of the subscription
subowner oid pg_authid.oid Owner of the subscription
subenabled bool   If true, the subscription is enabled and should be replicating.
subsynccommit text   Contains the value of the synchronous_commit setting for the subscription workers.
subconninfo text   Connection string to the upstream database
subslotname name   Name of the replication slot in the upstream database (also used for the local replication origin name); null represents NONE
subpublications text[]   Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.