51.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 51.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 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 . |