• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_REPLICATION_SLOTS

PG_REPLICATION_SLOTS

PG_REPLICATION_SLOTS views the replication node information.

Table 1 PG_REPLICATION_SLOTS columns

Name

Type

Description

slot_name

text

Name of a replication node

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

restart_lsn

text

Xlog file information on the replication node

dummy_standby

Boolean

Whether the replication node is the dummy standby node