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