PostgreSQL: Documentation: 12: 48.3. Streaming Replication Protocol Interface

September 4, 2025: PostgreSQL 18 RC 1 Released!

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: 18 / devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

48.3. Streaming Replication Protocol Interface
Prev	Up	Chapter 48. Logical Decoding	Home	Next

48.3. Streaming Replication Protocol Interface

The commands

CREATE_REPLICATION_SLOT slot_name LOGICAL output_plugin
DROP_REPLICATION_SLOT slot_name [ WAIT ]
START_REPLICATION SLOT slot_name LOGICAL ...

are used to create, drop, and stream changes from a replication slot, respectively. These commands are only available over a replication connection; they cannot be used via SQL. See Section 52.4 for details on these commands.

The command pg_recvlogical can be used to control logical decoding over a streaming replication connection. (It uses these commands internally.)

Prev	Up	Next
48.2. Logical Decoding Concepts	Home	48.4. Logical Decoding SQL Interface