Movatterモバイル変換

oidoid

Row identifier

subdbidoid (referencespg_database.oid)

OID of the database that the subscription resides in

subskiplsnpg_lsn

Finish LSN of the transaction whose changes are to be skipped, if a valid LSN; otherwise0/0.

subnamename

Name of the subscription

subowneroid (referencespg_authid.oid)

Owner of the subscription

subenabledbool

If true, the subscription is enabled and should be replicating

subbinarybool

If true, the subscription will request that the publisher send data in binary format

substreamchar

Controls how to handle the streaming of in-progress transactions:f = disallow streaming of in-progress transactions,t = spill the changes of in-progress transactions to disk and apply at once after the transaction is committed on the publisher and received by the subscriber,p = apply changes directly using a parallel apply worker if available (same ast if no worker is available)

subtwophasestatechar

State codes for two-phase mode:d = disabled,p = pending enablement,e = enabled

subdisableonerrbool

If true, the subscription will be disabled if one of its workers detects an error

subpasswordrequiredbool

If true, the subscription will be required to specify a password for authentication

subrunasownerbool

If true, the subscription will be run with the permissions of the subscription owner

subfailoverbool

If true, the associated replication slots (i.e. the main slot and the table sync slots) in the upstream database are enabled to be synchronized to the standbys

subconninfotext

Connection string to the upstream database

subslotnamename

Name of the replication slot in the upstream database (also used for the local replication origin name); null representsNONE

subsynccommittext

Thesynchronous_commit setting for the subscription's workers to use

subpublicationstext[]

Array of subscribed publication names. These reference publications defined in the upstream database. For more on publications seeSection 28.1.

suborigintext

The origin value must be eithernone orany. The default isany. Ifnone, the subscription will request the publisher to only send changes that don't have an origin. Ifany, the publisher sends changes regardless of their origin.