This page in other versions: 9.4  |  Development versions: devel

48.39. pg_replication_slots

The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state.

For more on replication slots, see Section 25.2.6 and Chapter 46.

Table 48-39. pg_replication_slots Columns

Name Type References Description
slot_name name   A unique, cluster-wide identifier for the replication slot
plugin name   The base name of the shared object containing the output plugin this logical slot is using, or null for physical slots.
slot_type text   The slot type - physical or logical
datoid oid pg_database.oid The OID of the database this slot is associated with, or null. Only logical slots have an associated database.
database text pg_database.datname The name of the database this slot is associated with, or null. Only logical slots have an associated database.
active boolean   True if this slot is currently actively being used
xmin xid   The oldest transaction that this slot needs the database to retain. VACUUM cannot remove tuples deleted by any later transaction.
catalog_xmin xid   The oldest transaction affecting the system catalogs that this slot needs the database to retain. VACUUM cannot remove catalog tuples deleted by any later transaction.
restart_lsn pg_lsn   The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints.
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group