From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Jesper Pedersen <jesper.pedersen@redhat.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg_receivewal documentation
Date: Wed, 24 Jul 2019 15:03:04 +0200
Message-ID: <20190724150304.02882f38@firost> (raw)
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>
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,
Attachments:0001-Add-doc-details-for-pg_receivewal-with-remote_apply.patch (text/x-patch, 1.1K) download
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.sgmlindex 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: jgdr@dalibo.com, michael@paquier.xyz, jesper.pedersen@redhat.com
Subject: Re: pg_receivewal documentation
In-Reply-To: <20190724150304.02882f38@firost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox