52.56. pg_subscription
The catalogpg_subscription contains all existing logical replication subscriptions. For more information about logical replication seeChapter 29.
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 52.56. pg_subscription Columns
Column Type Description |
|---|
Row identifier |
OID of the database that the subscription resides in |
Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise |
Name of the subscription |
Owner of the subscription |
If true, the subscription is enabled and should be replicating |
If true, the subscription will request that the publisher send data in binary format |
If true, the subscription will allow streaming of in-progress transactions |
State codes for two-phase mode: |
If true, the subscription will be disabled if one of its workers detects an error |
Connection string to the upstream database |
Name of the replication slot in the upstream database (also used for the local replication origin name); null represents |
The |
Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications seeSection 29.1. |