Re: BUG #19432: recovery fails at invalid checkpoint record - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #19432: recovery fails at invalid checkpoint record
Date
Msg-id 1b26be28f1e33162728da58162fcb80874fae4d8.camel@cybertec.at
Whole thread Raw
In response to Re: BUG #19432: recovery fails at invalid checkpoint record  (Felix Hamme <felix.hamme@ionos.com>)
List pgsql-bugs
On Mon, 2026-03-16 at 14:56 +0100, Felix Hamme wrote:
> I'm tempted to use a restore_command which does cp for history files
> and mv for WAL files, to optimize performance and disk usage.
> An AI told me that a second restore attempt for the same WAL file
> could only happen if recovery is resumed after a crash.

Don't do that.  Make the restore_command idempotent.
Trying to optimize for storage space often causes problems elsewhere.

Yours,
Laurenz Albe



pgsql-bugs by date:

Previous
From: Felix Hamme
Date:
Subject: Re: BUG #19432: recovery fails at invalid checkpoint record
Next
From: PG Bug reporting form
Date:
Subject: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables