On Wed, Jan 12, 2022 at 07:19:48AM +0530, Bharath Rupireddy wrote: > > > > Can the postgres server ever have/generate out of sequence WAL files? > > For instance, 000000010000020C000000A2, 000000010000020C000000A3, > > 000000010000020C000000A5 and so on, missing 000000010000020C000000A4. > > Manual/Accidental deletion of the WAL files can happes, but are there > > any other extreme situations (like recycling, removing old WAL files > > etc.) caused by the postgres server leading to missing WAL files?
By definition there shouldn't be such situation, as it would otherwise be a (critical) bug. > > What happens when postgres server finds missing WAL file during > > crash/standby recovery? The recovery should fail.