pg_subscription

The pg_subscription catalog contains all existing logical replication subscriptions.

Column name	Data type	Description
`oid`	`oid`	A row identifier.
`subdbid`	`oid` (references `pg_database.oid`)	The OID of the database in which the subscription resides.
`subskiplsn`	`pg_lsn`	The final LSN of the transaction whose changes should be skipped if the LSN is valid. Otherwise, the value is `0/0`.
`subname`	`name`	The name of the subscription.
`subowner`	`oid` (references `pg_authid.oid`)	The OID of the role that owns the subscription.
`subenabled`	`bool`	Specifies whether the subscription is enabled and should be replicating (`TRUE`) or not (`FALSE`).
`subbinary`	`bool`	Specifies whether the subscription requires that the publisher sends data in a binary format (`TRUE`) or not (`FALSE`).
`substream`	`char`	The setting that controls how to handle the streaming of in-progress transactions. The possible values are: `f` – Forbid streaming. `t` – Write changes to disk and process them after commits. `p` – Apply changes directly using a parallel apply worker if available. Otherwise, it behaves like `t`.
`subtwophasestate`	`char`	The two-phase mode state. The possible values are: `d` – Disabled. `p` – Pending enablement. `p` – Pending enablement. `e` – Enabled.
`subdisableonerr`	`bool`	Specifies whether the subscription will be disabled if any of its workers detects an error (`TRUE`) or not (`FALSE`).
`subpasswordrequired`	`bool`	Specifies whether the subscription must specify a password for authentication (`TRUE`) or not (`FALSE`).
`subrunasowner`	`bool`	Specifies whether the subscription will run with the permissions of the subscription owner (`TRUE`) or not (`FALSE`).
`subfailover`	`bool`	Specifies whether the associated replication slots in the upstream database are allowed to synchronize to standby servers (`TRUE`) or not (`FALSE`).
`subconninfo`	`text`	The connection string to the upstream database.
`subslotname`	`name`	The name of the replication slot in the upstream database. Also used as the local replication origin name. `NULL` – No replication slot is used (equivalent to `NONE`).
`subsynccommit`	`text`	The `synchronous_commit` setting used by the subscription’s workers.
`subpublications`	`text[]`	An array of subscribed publication names, referencing publications defined in the upstream database.
`suborigin`	`text`	The origin value, either `none` or `any`. The possible values are: `none` – The subscription requests only changes without an origin. `any` – All changes are sent regardless of origin.