Postgres Pro
Downloads
Home   >   mailing lists

Can there ever be out of sequence WAL files? - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Can there ever be out of sequence WAL files?
Date
Msg-id CALj2ACWzYg4uX-ZXcKJVLodbFNucn83MF9dBdhZbHggyHONkDw@mail.gmail.com
Whole thread Raw
Responses Re: Can there ever be out of sequence WAL files?  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: sequences vs. synchronous replication
Next
From: "wangw.fnst@fujitsu.com"
Date:
Subject: RE: Optionally automatically disable logical replication subscriptions on error