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

Commit1c42346

Browse files
committed
Doc: Clarify interactions of pg_receivewal with remote_apply
Using pg_receivewal with synchronous_commit = remote_apply set in thebackend is incompatible if pg_receivewal is a synchronous standby as itnever applies WAL, so document this problem and solutions to it.Backpatch to 9.6, where remote_apply has been added.Author: Robert Haas, Jesper PedersenReviewed-by: Laurenz Albe, Álvaro Herrera, Michael PaquierDiscussion:https://postgr.es/m/1427a2d3-1e51-9335-1931-4f8853d90d5e@redhat.comBackpatch-through: 9.6
1 parent46fb7ff commit1c42346

File tree

1 file changed

+11
-1
lines changed

1 file changed

+11
-1
lines changed

‎doc/src/sgml/ref/pg_receivewal.sgml

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -52,7 +52,17 @@ PostgreSQL documentation
5252
Unlike the WAL receiver of a PostgreSQL standby server, <application>pg_receivewal</>
5353
by default flushes WAL data only when a WAL file is closed.
5454
The option <option>--synchronous</> must be specified to flush WAL data
55-
in real time.
55+
in real time. Since <application>pg_receivewal</application> does not
56+
apply WAL, you should not allow it to become a synchronous standby when
57+
<xref linkend="guc-synchronous-commit"/> equals
58+
<literal>remote_apply</literal>. If it does, it will appear to be a
59+
standby that never catches up, and will cause transaction commits to
60+
block. To avoid this, you should either configure an appropriate value
61+
for <xref linkend="guc-synchronous-standby-names"/>, or specify
62+
<varname>application_name</varname> for
63+
<application>pg_receivewal</application> that does not match it, or
64+
change the value of <varname>synchronous_commit</varname> to
65+
something other than <literal>remote_apply</literal>.
5666
</para>
5767

5868
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp