Re: pg_receivewal documentation - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_receivewal documentation
Date
Msg-id 20190718052909.GF1416@paquier.xyz
Whole thread Raw
In response to Re: pg_receivewal documentation  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: pg_receivewal documentation  (Jesper Pedersen <jesper.pedersen@redhat.com>)
List pgsql-hackers
On Wed, Jul 17, 2019 at 11:21:06PM +0200, Laurenz Albe wrote:
> 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>.

Or more simply like that?
"Note that while WAL will be flushed with this setting,
pg_receivewal never applies it, so synchronous_commit must not be set
to remote_apply if pg_receivewal is a synchronous standby, be it a
member of a priority-based (FIRST) or a quorum-based (ANY) synchronous
replication setup."
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: partition routing layering in nodeModifyTable.c
Next
From: Michael Paquier
Date:
Subject: Re: Intermittent pg_ctl failures on Windows