Обсуждение: pgsql: Doc: Clarify interactions of pg_receivewal with remote_apply

Поиск
Список
Период
Сортировка

pgsql: Doc: Clarify interactions of pg_receivewal with remote_apply

От
Michael Paquier
Дата:
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: https://postgr.es/m/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(-)


Re: pgsql: Doc: Clarify interactions of pg_receivewal withremote_apply

От
Stefan Kaltenbrunner
Дата:
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: https://postgr.es/m/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



Re: pgsql: Doc: Clarify interactions of pg_receivewal withremote_apply

От
Michael Paquier
Дата:
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

Вложения