flâneur — a map of the web's best reading

PostgreSQL: Documentation: 17: 53.5. Logical Streaming Replication Protocol

postgresql.org · 910 words · saved by 1 readers

This section describes the logical replication protocol, which is the message flow started by the START_REPLICATION SLOT slot_name LOGICAL replication command. The logical streaming replication protocol builds on the primitives of the physical streaming replication protocol. PostgreSQL logical decoding supports output plugins. pgoutput is the standard one used for the built-in logical replication. Using the START_REPLICATION command, pgoutput accepts the following options: Protocol version. Currently versions 1, 2, 3, and 4 are supported. A valid version is required. Version 2 is supported only for server version 14 and above, and it allows streaming of large in-progress transactions. Version 3 is supported only for server version 15 and above, and it allows streaming of two-phase commits. Version 4 is supported only for server version 16 and above, and it allows streams of large in-progress transactions to be applied in parallel. Comma separated list of publication names for which to

PostgreSQL: Documentation: 18: 54.5. Logical Streaming Replication Protocol June 4, 2026: PostgreSQL 19 Beta 1 Released! Documentation → PostgreSQL 18 Supported Versions: Current ( 18 ) / 17 / 16 / 15 / 14 Development Versions: 19 / devel Unsupported versions: 13 / 12 / 11 / 10 54.5. Logical Streaming Replication Protocol Prev Up Chapter 54. Frontend/Backend Protocol Home Next 54.5. Logical Streaming Replication Protocol # 54.5.1. Logical Streaming Replication Parameters 54.5.2. Logical Replication Protocol Messages 54.5.3. Logical Replication Protocol Message Flow This section describes

Explore this link on the map →

saved by

related reading