50.52. pg_subscription
The catalogpg_subscription contains all existing logical replication subscriptions. For more information about logical replication seeChapter 30.
Unlike most system catalogs,pg_subscription is shared across all databases of a cluster: there is only one copy ofpg_subscription per cluster, not one per database.
Access to the columnsubconninfo is revoked from normal users, because it could contain plain-text passwords.
Table 50.52. pg_subscription Columns
| Name | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier (hidden attribute; must be explicitly selected) | |
subdbid | oid | | OID of the database which the subscription resides in |
subname | name | Name of the subscription | |
subowner | oid | | Owner of the subscription |
subenabled | bool | If true, the subscription is enabled and should be replicating. | |
subsynccommit | text | Contains the value of thesynchronous_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 representsNONE | |
subpublications | text[] | Array of subscribed publication names. These reference the publications on the publisher server. For more on publications seeSection 30.1. |