From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | jesper(dot)pedersen(at)redhat(dot)com, Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_receivewal documentation |
Date: | 2019-07-17 21:21:06 |
Message-ID: | 184780f1f90a31c4c8b53f0e6328bf5aaae4f786.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2019-07-17 22:08:47 | Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter |
Previous Message | Darafei Komяpa Praliaskouski | 2019-07-17 21:20:21 | Re: Unwanted expression simplification in PG12b2 |