PostgreSQL: Documentation: 17: 53.5. Logical Streaming Replication Protocol
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
- PostgreSQL: Documentation: 18: 54.1. Overviewpostgresql.org
- Ingest data from self-hosted PostgreSQL | Materialize Documentationmaterialize.com
- Postgres WAL Files and Sequence Numbers | Crunchy Data Blogcrunchydata.com
- debezium-examples/postgres-toast at main · debezium/debezium-examples · GitHubgithub.com
- Flink CDC for Postgres: Lessons Learned | sap1ens.comsap1ens.com
- PostgreSQL CDC - RisingWavedocs.risingwave.com
- Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com
- PostgreSQL: Documentation: 16: Chapter 31. Logical Replicationpostgresql.org
- Debezium and TimescaleDBdebezium.io
- Patching the PostgreSQL JDBC Driverengineering.zalando.com
- Scaling PostgreSQL to power 800 million ChatGPT users | OpenAIopenai.com
- DBMS Musings: It’s Time to Move on from Two Phase Commitdbmsmusings.blogspot.com