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.
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
Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications see Section 30.1.