Re: pg_receivewal documentation
Laurenz Albe <laurenz.albe@cybertec.at>
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: jesper.pedersen@redhat.com, Michael Paquier <michael@paquier.xyz>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-07-17T21:21:06Z
Lists: pgsql-hackers
On Wed, 2019-07-17 at 13:59 -0400, Jesper Pedersen wrote: > + <para> > + Note that while WAL will be flushed with this setting, > + <application>pg_receivewal</application> never applies it, so > + <xref linkend="guc-synchronous-commit"/> must not be set to > + <literal>remote_apply</literal> or <literal>on</literal> > + if <application>pg_receivewal</application> is the only synchronous standby. > + Similarly, if <application>pg_receivewal</application> is part of a > + priority-based synchronous replication setup (<literal>FIRST</literal>), > + or a quorum-based setup (<literal>ANY</literal>) it won't count towards > + the policy specified if <xref linkend="guc-synchronous-commit"/> is > + set to <literal>remote_apply</literal> or <literal>on</literal>. > + </para> That's factually wrong. "on" (wait for WAL flush) works fine with pg_receivewal, only "remote_apply" doesn't. Ok, here's another attempt: Note that while WAL will be flushed with this setting, <application>pg_receivewal</application> never applies it, so <xref linkend="guc-synchronous-commit"/> must not be set to <literal>remote_apply</literal> if <application>pg_receivewal</application> is the only synchronous standby. Similarly, it is no use adding <application>pg_receivewal</application> to a priority-based (<literal>FIRST</literal>) or a quorum-based (<literal>ANY</literal>) synchronous replication setup if <xref linkend="guc-synchronous-commit"/> is set to <literal>remote_apply</literal>. Yours, Laurenz Albe
Commits
-
Doc: Clarify interactions of pg_receivexlog with remote_apply
- 4a25ed16400c 9.6.15 landed
-
Doc: Clarify interactions of pg_receivewal with remote_apply
- 1c423463e4b9 10.10 landed
- 059e22693b23 11.5 landed
- a15a40aaaedf 12.0 landed
- fd7d387e0548 13.0 landed