Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Usage
Change history
References
Categories
See also

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

PostgreSQL 14
- option two_phase added (commit 19890a06)
PostgreSQL 10
- option temporary added (commit a924c327)
PostgreSQL 9.4
- added (commit b89e1510)

References

PostgreSQL documentation: Replication SQL Functions

Categories

See also

pg_get_replication_slots(), pg_create_physical_replication_slot()