PG_REPLICATION_SLOTS
PG_REPLICATION_SLOTS displays the replication node information.
| Name | Type | Description |
|---|---|---|
| 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 |
Last Article: PG_PREPARED_XACTS
Next Article: PG_ROLES
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.