Date: Wed, 24 Jul 2019 15:03:04 +0200
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>
Subject: Re: pg_receivewal documentation
Message-ID: <20190724150304.02882f38@firost>
In-Reply-To: <20190724022928.GC14257@paquier.xyz>
References: <54779de5-f922-c0cf-629d-b582eded7265@redhat.com>
	<20190716050555.GA1439@paquier.xyz>
	<ebed4b9043b222d486ea3f0e44e7dcd242a80781.camel@cybertec.at>
	<65c3ecdf-8995-34cb-83c4-50068877e632@redhat.com>
	<20190717013835.GA2130@paquier.xyz>
	<CA+TgmoY-8im5GHnSf1zih8t66DOcy7CO+i_p01LbP6ck+Unhpg@mail.gmail.com>
	<20190722014851.GC1757@paquier.xyz>
	<9fea76ce-6912-c262-6f64-2b7c4496be65@redhat.com>
	<20190723000820.GA2059@paquier.xyz>
	<72d2d628-eff9-94dc-8ced-0869bfda4e80@redhat.com>
	<20190724022928.GC14257@paquier.xyz>
Organization: Dalibo
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="MP_/W7jqwww14IVqmBj_ToIMyry"
Precedence: bulk

--MP_/W7jqwww14IVqmBj_ToIMyry
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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,

--MP_/W7jqwww14IVqmBj_ToIMyry
Content-Type: text/x-patch
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename=0001-Add-doc-details-for-pg_receivewal-with-remote_apply.patch

From 01a7de92dbaae5a61d5ec7bd04bef1553467f29d Mon Sep 17 00:00:00 2001
From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Date: Wed, 24 Jul 2019 14:58:41 +0200
Subject: [PATCH] Add doc details for pg_receivewal with remote_apply

---
 doc/src/sgml/ref/pg_receivewal.sgml | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/pg_receivewal.sgml b/doc/src/sgml/ref/pg_receivewal.sgml
index 177e9211c0..abf55ce713 100644
--- a/doc/src/sgml/ref/pg_receivewal.sgml
+++ b/doc/src/sgml/ref/pg_receivewal.sgml
@@ -62,7 +62,12 @@ PostgreSQL documentation
    <varname>application_name</varname> for
    <application>pg_receivewal</application> that does not match it, or
    change the value of <varname>synchronous_commit</varname> to
-   something other than <literal>remote_apply</literal>.
+   something other than <literal>remote_apply</literal> either cluster wide or
+   just for a dedicated role to <application>pg_receivewal</application>:
+<programlisting>
+CREATE ROLE receivewal WITH LOGIN REPLICATION;
+ALTER ROLE receivewal SET synchronous_commit TO on;
+</programlisting>
   </para>
 
   <para>
-- 
2.20.1


--MP_/W7jqwww14IVqmBj_ToIMyry--