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

Commit2dca034

Browse files
committed
doc: Document that logical replication supports synchronous replication
Update the documentation a bit to include that logical replication aswell as other and third-party replication clients can participate insynchronous replication.
1 parentd8b3c81 commit2dca034

File tree

3 files changed

+39
-10
lines changed

3 files changed

+39
-10
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 19 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -3074,7 +3074,19 @@ include_dir 'conf.d'
30743074
(as shown by a state of <literal>streaming</literal> in the
30753075
<link linkend="monitoring-stats-views-table">
30763076
<literal>pg_stat_replication</></link> view).
3077-
Specifying more than one standby names can allow very high availability.
3077+
Specifying more than one synchronous standby can allow for very high
3078+
availability and protection against data loss.
3079+
</para>
3080+
<para>
3081+
The name of a standby server for this purpose is the
3082+
<varname>application_name</> setting of the standby, as set in the
3083+
standby's connection information. In case of a physical replication
3084+
standby, this should be set in the <varname>primary_conninfo</>
3085+
setting in <filename>recovery.conf</filename>; the default
3086+
is <literal>walreceiver</literal>. For logical replication, this can
3087+
be set in the connection information of the subscription, and it
3088+
defaults to the subscription name. For other replication stream
3089+
consumers, consult their documentation.
30783090
</para>
30793091
<para>
30803092
This parameter specifies a list of standby servers using
@@ -3136,15 +3148,12 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
31363148
as a synchronous standby.
31373149
</para>
31383150
<para>
3139-
The name of a standby server for this purpose is the
3140-
<varname>application_name</> setting of the standby, as set in the
3141-
<varname>primary_conninfo</> of the standby's WAL receiver. There is
3142-
no mechanism to enforce uniqueness. In case of duplicates one of the
3143-
matching standbys will be considered as higher priority, though
3144-
exactly which one is indeterminate.
3145-
The special entry <literal>*</> matches any
3146-
<varname>application_name</>, including the default application name
3147-
of <literal>walreceiver</>.
3151+
The special entry <literal>*</> matches any standby name.
3152+
</para>
3153+
<para>
3154+
There is no mechanism to enforce uniqueness of standby names. In case
3155+
of duplicates one of the matching standbys will be considered as
3156+
higher priority, though exactly which one is indeterminate.
31483157
</para>
31493158
<note>
31503159
<para>

‎doc/src/sgml/high-availability.sgml

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1056,6 +1056,18 @@ primary_slot_name = 'node_a_slot'
10561056
require commit waits, including both prepare and commit.
10571057
</para>
10581058

1059+
<para>
1060+
A synchronous standby can be a physical replication standby or a logical
1061+
replication subscriber. It can also be any other physical or logical WAL
1062+
replication stream consumer that knows how to send the appropriate
1063+
feedback messages. Besides the built-in physical and logical replication
1064+
systems, this includes special programs such
1065+
as <command>pg_receivewal</command> and <command>pg_recvlogical</command>
1066+
as well as some third-party replication systems and custom programs.
1067+
Check the respective documentation for details on synchronous replication
1068+
support.
1069+
</para>
1070+
10591071
<sect3 id="synchronous-replication-config">
10601072
<title>Basic Configuration</title>
10611073

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

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -184,6 +184,14 @@
184184
of pre-existing table data.
185185
</para>
186186

187+
<para>
188+
A logical replication subscription can be a standby for synchronous
189+
replication (see <xref linkend="synchronous-replication">). The standby
190+
name is by default the subscription name. An alternative name can be
191+
specified as <literal>application_name</literal> in the connection
192+
information of the subscription.
193+
</para>
194+
187195
<para>
188196
Subscriptions are dumped by <command>pg_dump</command> if the current user
189197
is a superuser. Otherwise a warning is written and subscriptions are

0 commit comments

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