pg_create_logical_replication_slot()

A function for creating a logical replication slot

pg_create_logical_replication_slot() is a system function for creating a logical replication slot.

pg_create_logical_replication_slot() was added in PostgreSQL 9.4.

Usage

PostgreSQL 14 ~

pg_create_logical_replication_slot ( slot_name name, plugin name [, temporary boolean , two_phase boolean ] ) → record ( slot_name name, lsn pg_lsn )

PostgreSQL 10 ~ PostgreSQL 13:

pg_create_logical_replication_slot ( slot_name name, plugin name [, temporary boolean ] ) → record ( slot_name name, lsn pg_lsn )

PostgreSQL 9.4 ~ PostgreSQL 9.6:

pg_create_logical_replication_slot ( slot_name name, plugin name ) → record ( slot_name name, lsn pg_lsn )

Change history

Categories

Logical replication, System function

See also

pg_get_replication_slots(), pg_create_physical_replication_slot()