Can there ever be out of sequence WAL files?

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Can there ever be out of sequence WAL files?
Date: 2021-12-28 02:15:23
Message-ID: CALj2ACWzYg4uX-ZXcKJVLodbFNucn83MF9dBdhZbHggyHONkDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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?

What happens when postgres server finds missing WAL file during
crash/standby recovery?

Thoughts?

Regards,
Bharath Rupireddy.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message wangw.fnst@fujitsu.com 2021-12-28 02:52:47 RE: Optionally automatically disable logical replication subscriptions on error
Previous Message Tomas Vondra 2021-12-28 01:39:51 Re: sequences vs. synchronous replication