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

Categories

Logical replication, Replication, System catalogue