Postgres Pro
Downloads
45.3. Streaming Replication Protocol Interface
Prev UpChapter 45. Logical DecodingHome Next

45.3. Streaming Replication Protocol Interface

The commands

  • CREATE_REPLICATION_SLOT slot_name LOGICAL output_plugin

  • DROP_REPLICATION_SLOT slot_name

  • 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 49.3 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 Home Next
45.2. Logical Decoding Concepts Up 45.4. Logical Decoding SQL Interface
pdf epub