PostgreSQL

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

48.2. Logical Decoding Concepts

Home

48.4. Logical Decoding SQL Interface