Horton

Re: [BUG] non archived WAL removed during production crash recovery

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

View thread View on postgr.es
From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-bugs@lists.postgresql.org, michael@paquier.xyz
Date: 2020-04-02T15:44:50Z
Lists: pgsql-bugs, pgsql-hackers 
On Thu, 2 Apr 2020 23:55:46 +0900
Fujii Masao <masao.fujii@oss.nttdata.com> wrote:

[...]
> > Well, it seems to me that this is what you suggested few paragraph away:
> > 
> >    «.ready files are removed when either archive_mode!=always in standby
> > mode»  
> 
> Yes, so I'm fine with that as the first consensus because the behavior
> is obviously better than the current one. *If* the case where no WAL files
> should be removed is found, I'd just like to propose the additional patch.

Do you mean to want to produce the next patch yourself?

Commits

  1. Fix interpolation in test name.

  2. Add more TAP coverage for archive status with crash recovery of standbys

  3. Fix handling of WAL segments ready to be archived during crash recovery

  4. Fix WAL recycling on standbys depending on archive_mode