From: Michael Paquier <michael@paquier.xyz>
To: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: masao.fujii@oss.nttdata.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: [BUG] non archived WAL removed during production crash recovery
Date: Wed, 22 Apr 2020 08:07:52 +0900
Message-ID: <20200421230752.GD33034@paquier.xyz> (raw)
In-Reply-To: <20200422000022.7aa6a62b@firost>
References: <20200421021501.GE77439@paquier.xyz>
<20200421.120925.76453535156648004.horikyota.ntt@gmail.com>
<20200421045739.GC6436@paquier.xyz>
<20200421.150817.1089565975398030716.horikyota.ntt@gmail.com>
<20200422000022.7aa6a62b@firost>
On Wed, Apr 22, 2020 at 12:00:22AM +0200, Jehan-Guillaume de Rorthais wrote:
> That leads me an idea where we would keep the ControlFile data up-to-date in
> shared memory. There's a few duplicates between ControlFile and XLogCtl, so
> maybe it could make the code a little simpler at some other places than just
> fixing $SUBJECT using DBState? I'm not sure of the implications and impacts
> though. This seems way bigger than the current fix and with many traps on the
> way. Maybe we could discuss this in another thread if you think it deserves it?
It seems to me that this could have wider applications than just the
recovery state, no? I would recommend to keep this discussion on a
separate thread to give more visibility to the topic.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../20200421230752.GD33034@paquier.xyz/2-signature.asc)
download
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-bugs@postgresql.org
Cc: michael@paquier.xyz, jgdr@dalibo.com, horikyota.ntt@gmail.com, masao.fujii@oss.nttdata.com, pgsql-bugs@lists.postgresql.org
Subject: Re: [BUG] non archived WAL removed during production crash recovery
In-Reply-To: <20200421230752.GD33034@paquier.xyz>
* 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