↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10
Historical version. PostgreSQL 13 reached end of support in November 2025. See the current version for supported releases.
51.52. pg_subscription
Prev  Up Chapter 51. System Catalogs Home  Next

51.52. 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.52. pg_subscription Columns

Column Type

Description

oid oid

Row identifier

subdbid oid (references pg_database.oid)

OID of the database which the subscription resides in

subname name

Name of the subscription

subowner oid (references pg_authid.oid)

Owner of the subscription

subenabled bool

If true, the subscription is enabled and should be replicating.

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

subsynccommit text

Contains the value of the synchronous_commit setting for the subscription workers.

subpublications text[]

Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 30.1.

Prev  Up  Next
51.51. pg_statistic_ext_data  Home  51.53. pg_subscription_rel

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.