pg_replication_slots
A system catalogue view listing of all replication slots
pg_replication_slots is a system catalogue view listing of all replication slots available.
pg_replication_slots was added in PostgreSQL 9.4 (commit 858ec118).
Definition by PostgreSQL version
pg_replication_slots (PostgreSQL 13)
View "pg_catalog.pg_replication_slots"
Column | Type | Collation | Nullable | Default
---------------------+---------+-----------+----------+---------
slot_name | name | | |
plugin | name | | |
slot_type | text | | |
datoid | oid | | |
database | name | | |
temporary | boolean | | |
active | boolean | | |
active_pid | integer | | |
xmin | xid | | |
catalog_xmin | xid | | |
restart_lsn | pg_lsn | | |
confirmed_flush_lsn | pg_lsn | | |
wal_status | text | | |
min_safe_lsn | pg_lsn | | |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 12)
View "pg_catalog.pg_replication_slots"
Column | Type | Collation | Nullable | Default
---------------------+---------+-----------+----------+---------
slot_name | name | | |
plugin | name | | |
slot_type | text | | |
datoid | oid | | |
database | name | | |
temporary | boolean | | |
active | boolean | | |
active_pid | integer | | |
xmin | xid | | |
catalog_xmin | xid | | |
restart_lsn | pg_lsn | | |
confirmed_flush_lsn | pg_lsn | | |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 11)
View "pg_catalog.pg_replication_slots"
Column | Type | Collation | Nullable | Default
---------------------+---------+-----------+----------+---------
slot_name | name | | |
plugin | name | | |
slot_type | text | | |
datoid | oid | | |
database | name | | |
temporary | boolean | | |
active | boolean | | |
active_pid | integer | | |
xmin | xid | | |
catalog_xmin | xid | | |
restart_lsn | pg_lsn | | |
confirmed_flush_lsn | pg_lsn | | |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 10)
View "pg_catalog.pg_replication_slots"
Column | Type | Collation | Nullable | Default
---------------------+---------+-----------+----------+---------
slot_name | name | | |
plugin | name | | |
slot_type | text | | |
datoid | oid | | |
database | name | | |
temporary | boolean | | |
active | boolean | | |
active_pid | integer | | |
xmin | xid | | |
catalog_xmin | xid | | |
restart_lsn | pg_lsn | | |
confirmed_flush_lsn | pg_lsn | | |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 9.6)
View "pg_catalog.pg_replication_slots"
Column | Type | Modifiers
---------------------+---------+-----------
slot_name | name |
plugin | name |
slot_type | text |
datoid | oid |
database | name |
active | boolean |
active_pid | integer |
xmin | xid |
catalog_xmin | xid |
restart_lsn | pg_lsn |
confirmed_flush_lsn | pg_lsn |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 9.5)
View "pg_catalog.pg_replication_slots"
Column | Type | Modifiers
--------------+---------+-----------
slot_name | name |
plugin | name |
slot_type | text |
datoid | oid |
database | name |
active | boolean |
active_pid | integer |
xmin | xid |
catalog_xmin | xid |
restart_lsn | pg_lsn |
Documentation: pg_replication_slots
pg_replication_slots (PostgreSQL 9.4)
View "pg_catalog.pg_replication_slots"
Column | Type | Modifiers
--------------+---------+-----------
slot_name | name |
plugin | name |
slot_type | text |
datoid | oid |
database | name |
active | boolean |
xmin | xid |
catalog_xmin | xid |
restart_lsn | pg_lsn |
Documentation: pg_replication_slots
Change history
- PostgreSQL 13
- PostgreSQL 10
- column
temporaryadded (commit a924c327)
- column
- PostgreSQL 9.6
- column
confirmed_flush_lsnadded (commit 3f811c2d)
- column
- PostgreSQL 9.5
- column
active_pidadded (commit d811c037)
- column
- PostgreSQL 9.4
- added (commit 858ec118)
References
- PostgreSQL documentation: pg_replication_slot