Re: pgsql: Fix handling of WAL segments ready to be archived duringcrash r - Mailing list pgsql-committers

From Jehan-Guillaume de Rorthais
Subject Re: pgsql: Fix handling of WAL segments ready to be archived duringcrash r
Date
Msg-id 20200427122908.0275206c@firost
Whole thread Raw
In response to Re: pgsql: Fix handling of WAL segments ready to be archived duringcrash r  (Michael Paquier <michael@paquier.xyz>)
List pgsql-committers
On Sat, 25 Apr 2020 09:31:14 +0900
Michael Paquier <michael@paquier.xyz> wrote:

> On Fri, Apr 24, 2020 at 05:30:21PM +0900, Kyotaro Horiguchi wrote:
> > I think we can reimplement them by waiting
> > pg_stat_archiver.last_failed_wal at least for archive_mode=always
> > case. I'm not sure about the case where archive_mode=on, though.  
> 
> Yeah, the second case is more tricky, and there is no point to add a
> poll query using pg_stat_file() on a .ready file either.

I suggested a patch in the original thread, waiting for the LSN gathered on 
the primary.



pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Fwd: Detecting renamed columns via pgouput in logicalreplication ?
Next
From: Peter Eisentraut
Date:
Subject: pgsql: pg_dump: Replace can't-happen error with assertion