52.52. pg_subscription

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

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 52.52. pg_subscription Columns

Name	Type	References	Description
oid	oid		Row identifier (hidden attribute; must be explicitly selected)
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 local replication origin name.
subpublications	text[]		Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see Section 31.1.