Updated on 2024-11-05 GMT+08:00

PGXC_REPLICATION_SLOTS

PGXC_REPLICATION_SLOTS displays the replication information of DNs in the cluster. All columns except node_name are the same as those in the PG_REPLICATION_SLOTS view. Only users with system administrator permissions can access this view.

Table 1 PGXC_REPLICATION_SLOTS columns

Column

Type

Description

node_name

text

Node name

slot_name

text

Name of a replication node

plugin

name

Name of the output plug-in of the logical replication slot

slot_type

text

Type of a replication node

datoid

oid

OID of the database on the replication node

database

name

Name of the database on the replication node

active

boolean

Whether the replication node is active

xmin

xid

Transaction ID of the replication node

catalog_xmin

text

ID of the earliest-decoded transaction corresponding to the logical replication slot

restart_lsn

text

Xlog file information on the replication node

dummy_standby

boolean

Whether the replication node is the dummy standby node