From ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:18:09 +0200 Subject: Merging upstream version 15.6. Signed-off-by: Daniel Baumann --- .../sgml/html/protocol-logical-replication.html | 35 ++++++++++++++++++---- 1 file changed, 30 insertions(+), 5 deletions(-) (limited to 'doc/src/sgml/html/protocol-logical-replication.html') diff --git a/doc/src/sgml/html/protocol-logical-replication.html b/doc/src/sgml/html/protocol-logical-replication.html index e8619da..21017f4 100644 --- a/doc/src/sgml/html/protocol-logical-replication.html +++ b/doc/src/sgml/html/protocol-logical-replication.html @@ -1,5 +1,5 @@ -55.5. Logical Streaming Replication Protocol
55.5. Logical Streaming Replication Protocol
Prev UpChapter 55. Frontend/Backend ProtocolHome Next

55.5. Logical Streaming Replication Protocol

55.5.1. Logical Streaming Replication Parameters
55.5.2. Logical Replication Protocol Messages
55.5.3. Logical Replication Protocol Message Flow

+55.5. Logical Streaming Replication Protocol

55.5. Logical Streaming Replication Protocol
Prev UpChapter 55. Frontend/Backend ProtocolHome Next

55.5. Logical Streaming Replication Protocol

55.5.1. Logical Streaming Replication Parameters
55.5.2. Logical Replication Protocol Messages
55.5.3. Logical Replication Protocol Message Flow

This section describes the logical replication protocol, which is the message flow started by the START_REPLICATION SLOT slot_name @@ -7,15 +7,19 @@

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.

55.5.1. Logical Streaming Replication Parameters

- The logical replication START_REPLICATION command - accepts following parameters: + Using the START_REPLICATION command, + pgoutput accepts the following options:

proto_version

Protocol version. Currently versions 1, 2, - and 3 are supported. + and 3 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. @@ -28,6 +32,27 @@ Comma separated list of publication names for which to subscribe (receive changes). The individual publication names are treated as standard objects names and can be quoted the same as needed. + At least one publication name is required. +

+ binary +

+ Boolean option to use binary transfer mode. Binary mode is faster + than the text mode but slightly less robust. +

+ messages +

+ Boolean option to enable sending the messages that are written + by pg_logical_emit_message. +

+ streaming +

+ Boolean option to enable streaming of in-progress transactions. + Minimum protocol version 2 is required to turn it on. +

+ two_phase +

+ Boolean option to enable two-phase transactions. Minimum protocol + version 3 is required to turn it on.

55.5.2. Logical Replication Protocol Messages

@@ -81,4 +106,4 @@ cache the contents of Type messages, and first consult that cache to see if the type OID is defined there. If not, look up the type OID locally. -

Prev Up Next
55.4. Streaming Replication Protocol Home 55.6. Message Data Types
\ No newline at end of file +

Prev Up Next
55.4. Streaming Replication Protocol Home 55.6. Message Data Types
\ No newline at end of file -- cgit v1.2.3