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 0000000200003B6800000062. This is
unfortunate,because the oldest WAL segment that actually exists on disk is 0000000200003F1100000004, so the archive
scriptis failing repeatedly because of the missing segment.
The system is not actually missing important (for recovery) WAL segments, at least:
Latest checkpoint's REDO WAL file: 000000020000417600000029
I'd like to "catch up" the archiver such that it is operating on files that actually exist; besides setting
archive_commandto '/bin/true' and letting it chew through the old ones, is there a way of safely advancing the position
ofthe archiver?
--
-- Christophe Pettus
xof@thebuild.com