Re: pg_receivewal documentation

Jehan-Guillaume de Rorthais <jgdr@dalibo.com>

From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Jesper Pedersen <jesper.pedersen@redhat.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-07-24T13:03:04Z
Lists: pgsql-hackers

Attachments

Hi,

On Wed, 24 Jul 2019 11:29:28 +0900
Michael Paquier <michael@paquier.xyz> wrote:

> On Tue, Jul 23, 2019 at 08:00:41AM -0400, Jesper Pedersen wrote:
> > Sure.  
> 
> Thanks.  Applied down to 9.6 where remote_apply has been introduced,
> with tweaks for 9.6 as the tool is named pg_receivexlog there.

Sorry to step in so lately.

Unless I am missing something, another solution might be to use a dedicated
role to pg_receive{xlog|wal} with synchronous_commit lower than
remote_apply.

Not sure we want to add such detail, but if you consider it useful, you'll find
a patch in attachment.

Regards,

Commits

  1. Doc: Clarify interactions of pg_receivexlog with remote_apply

  2. Doc: Clarify interactions of pg_receivewal with remote_apply