Re: Advancing the archiver position safely

2020-08-06 Thread Christophe Pettus
> On Aug 6, 2020, at 18:45, Jerry Sievers wrote: > Deleting the .ready file should allow the archiver to get past the > missing file. Ah, excellent, yes. -- -- Christophe Pettus x...@thebuild.com

Re: Advancing the archiver position safely

2020-08-06 Thread Jerry Sievers
Christophe Pettus writes: > I've encountered a rather unusual situation (PostgreSQL 9.6). On a > particular server, for reasons I've not fully diagnosed, the archiver > thinks that the current WAL segment to be archived is > 00023B680062. This is unfortunate, because the oldest WAL

Advancing the archiver position safely

2020-08-06 Thread Christophe Pettus
I've encountered a rather unusual situation (PostgreSQL 9.6). On a particular server, for reasons I've not fully diagnosed, the archiver thinks that the current WAL segment to be archived is 00023B680062. This is unfortunate, because the oldest WAL segment that actually exists on d