Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitad4a9f1

Browse files
author
Amit Kapila
committed
Doc: Add missing pgoutput options.
We forgot to update the docs while adding new options in pgoutput.Author: Emre HasegeliReviewed-by: Peter Smith, Amit KapilaBackpatch-through: 12Discussion:https://postgr.es/m/CAE2gYzwdwtUbs-tPSV-QBwgTubiyGD2ZGsSnAVsDfAGGLDrGOA%40mail.gmail.com
1 parentab04c19 commitad4a9f1

File tree

2 files changed

+64
-5
lines changed

2 files changed

+64
-5
lines changed

‎doc/src/sgml/logical-replication.sgml‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1451,7 +1451,8 @@ CONTEXT: processing remote data for replication origin "pg_16395" during "INSER
14511451
implemented by <quote>walsender</quote> and <quote>apply</quote>
14521452
processes. The walsender process starts logical decoding (described
14531453
in <xref linkend="logicaldecoding"/>) of the WAL and loads the standard
1454-
logical decoding plugin (pgoutput). The plugin transforms the changes read
1454+
logical decoding output plugin (<literal>pgoutput</literal>). The plugin
1455+
transforms the changes read
14551456
from WAL to the logical replication protocol
14561457
(see <xref linkend="protocol-logical-replication"/>) and filters the data
14571458
according to the publication specification. The data is then continuously

‎doc/src/sgml/protocol.sgml‎

Lines changed: 62 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -2559,7 +2559,10 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
25592559
<term><replaceable class="parameter">option_name</replaceable></term>
25602560
<listitem>
25612561
<para>
2562-
The name of an option passed to the slot's logical decoding plugin.
2562+
The name of an option passed to the slot's logical decoding output
2563+
plugin. See <xref linkend="protocol-logical-replication"/> for
2564+
options that are accepted by the standard (<literal>pgoutput</literal>)
2565+
plugin.
25632566
</para>
25642567
</listitem>
25652568
</varlistentry>
@@ -3088,12 +3091,18 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
30883091
the physical streaming replication protocol.
30893092
</para>
30903093

3094+
<para>
3095+
<productname>PostgreSQL</productname> logical decoding supports output
3096+
plugins. <literal>pgoutput</literal> is the standard one used for
3097+
the built-in logical replication.
3098+
</para>
3099+
30913100
<sect2 id="protocol-logical-replication-params">
30923101
<title>Logical Streaming Replication Parameters</title>
30933102

30943103
<para>
3095-
The logical replication<literal>START_REPLICATION</literal> command
3096-
accepts followingparameters:
3104+
Using the<literal>START_REPLICATION</literal> command,
3105+
<literal>pgoutput</literal>acceptsthefollowingoptions:
30973106

30983107
<variablelist>
30993108
<varlistentry>
@@ -3103,7 +3112,7 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
31033112
<listitem>
31043113
<para>
31053114
Protocol version. Currently versions <literal>1</literal>, <literal>2</literal>,
3106-
and <literal>3</literal> are supported.
3115+
and <literal>3</literal> are supported. A valid version is required.
31073116
</para>
31083117
<para>
31093118
Version <literal>2</literal> is supported only for server version 14
@@ -3125,6 +3134,55 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
31253134
Comma separated list of publication names for which to subscribe
31263135
(receive changes). The individual publication names are treated
31273136
as standard objects names and can be quoted the same as needed.
3137+
At least one publication name is required.
3138+
</para>
3139+
</listitem>
3140+
</varlistentry>
3141+
3142+
<varlistentry>
3143+
<term>
3144+
binary
3145+
</term>
3146+
<listitem>
3147+
<para>
3148+
Boolean option to use binary transfer mode. Binary mode is faster
3149+
than the text mode but slightly less robust.
3150+
</para>
3151+
</listitem>
3152+
</varlistentry>
3153+
3154+
<varlistentry>
3155+
<term>
3156+
messages
3157+
</term>
3158+
<listitem>
3159+
<para>
3160+
Boolean option to enable sending the messages that are written
3161+
by <function>pg_logical_emit_message</function>.
3162+
</para>
3163+
</listitem>
3164+
</varlistentry>
3165+
3166+
<varlistentry>
3167+
<term>
3168+
streaming
3169+
</term>
3170+
<listitem>
3171+
<para>
3172+
Boolean option to enable streaming of in-progress transactions.
3173+
Minimum protocol version 2 is required to turn it on.
3174+
</para>
3175+
</listitem>
3176+
</varlistentry>
3177+
3178+
<varlistentry>
3179+
<term>
3180+
two_phase
3181+
</term>
3182+
<listitem>
3183+
<para>
3184+
Boolean option to enable two-phase transactions. Minimum protocol
3185+
version 3 is required to turn it on.
31283186
</para>
31293187
</listitem>
31303188
</varlistentry>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp