pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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: Thu, 25 Jul 2019 10:29:44 +0200
Message-ID: <20190725102944.79a0be92@firost> (raw)
In-Reply-To: <20190725075817.GA7647@paquier.xyz>
References: <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>
	<20190724150304.02882f38@firost>
	<20190725075817.GA7647@paquier.xyz>

On Thu, 25 Jul 2019 16:58:17 +0900
Michael Paquier <michael@paquier.xyz> wrote:

> On Wed, Jul 24, 2019 at 03:03:04PM +0200, Jehan-Guillaume de Rorthais wrote:
> > 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.  
> 
> Aren't you confused by the same thing as I was upthread [1]?
> [1]: https://www.postgresql.org/message-id/20190710080423.GG1031@paquier.xyz
> 
> remote_apply affects all sessions.  So even if you use a replication
> role with synchronous_commit = on and have pg_receivewal use that with
> remote_apply set in postgresql.conf, then remote_apply is effective
> for all the other sessions so these will still be stuck at commit
> waiting for pg_receivewal to apply WAL if it is a synchronous
> standby.

Argh!

(Sorry for the noise)





view thread (37+ messages)

Message-ID: <20190725102944.79a0be92@firost>
Permalink:  ../20190725102944.79a0be92@firost/
Also on:    postgresql.org/message-id/20190725102944.79a0be92@firost

 · 

reply
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: <20190725102944.79a0be92@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