pgsql: Doc: Clarify interactions of pg_receivewal with remote_apply

Started by Michael Paquierabout 7 years ago3 messagescomitters
Jump to latest
#1Michael Paquier
michael@paquier.xyz

Doc: Clarify interactions of pg_receivewal with remote_apply

Using pg_receivewal with synchronous_commit = remote_apply set in the
backend is incompatible if pg_receivewal is a synchronous standby as it
never applies WAL, so document this problem and solutions to it.

Backpatch to 9.6, where remote_apply has been added.

Author: Robert Haas, Jesper Pedersen
Reviewed-by: Laurenz Albe, Álvaro Herrera, Michael Paquier
Discussion: /messages/by-id/1427a2d3-1e51-9335-1931-4f8853d90d5e@redhat.com
Backpatch-through: 9.6

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1c423463e4b91ec784b935895d77b6ceb3301141

Modified Files
--------------
doc/src/sgml/ref/pg_receivewal.sgml | 12 +++++++++++-
1 file changed, 11 insertions(+), 1 deletion(-)

#2Stefan Kaltenbrunner
stefan@kaltenbrunner.cc
In reply to: Michael Paquier (#1)
Re: pgsql: Doc: Clarify interactions of pg_receivewal with remote_apply

On 7/24/19 4:28 AM, Michael Paquier wrote:

Doc: Clarify interactions of pg_receivewal with remote_apply

Using pg_receivewal with synchronous_commit = remote_apply set in the
backend is incompatible if pg_receivewal is a synchronous standby as it
never applies WAL, so document this problem and solutions to it.

Backpatch to 9.6, where remote_apply has been added.

Author: Robert Haas, Jesper Pedersen
Reviewed-by: Laurenz Albe, Álvaro Herrera, Michael Paquier
Discussion: /messages/by-id/1427a2d3-1e51-9335-1931-4f8853d90d5e@redhat.com
Backpatch-through: 9.6

this broke building of the pdf target at least on 9.6 and 10:

10:

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=alabio&dt=2019-07-24%2004%3A18%3A05

9.6:

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=alabio&dt=2019-07-24%2004%3A17%3A48

Stefan

#3Michael Paquier
michael@paquier.xyz
In reply to: Stefan Kaltenbrunner (#2)
Re: pgsql: Doc: Clarify interactions of pg_receivewal with remote_apply

On Wed, Jul 24, 2019 at 08:23:13AM +0200, Stefan Kaltenbrunner wrote:

This broke building of the pdf target at least on 9.6 and 10:

I thought I tested that... Anyway, reproduced on both branches and
now fixed. Thanks Stefan for the report!
--
Michael