Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_REPLICATION_SLOTS

PG_REPLICATION_SLOTS

Updated at: Jul 15, 2020 GMT+08:00

PG_REPLICATION_SLOTS displays the replication node information.

Table 1 PG_REPLICATION_SLOTS columns

Name

Type

Description

slot_name

text

Name of a replication node

plugin

name

Name of the output plug-in corresponding to 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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel