Re: Fix crash during recovery when redo segment is missing

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Nitin Jadhav <nitinjadhavpostgres@gmail.com>

Cc: Kirill Reshke <reshkekirill@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>

Date: 2025-12-16T06:04:56Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add TAP test to check recovery when redo LSN is missing
- 15f68cebdcec 19 (unreleased) landed
Fail recovery when missing redo checkpoint record without backup_label
- 14161bca40a0 14.21 landed
- 95ef6f4904a5 15.16 landed
- 1aa57e9ed548 16.12 landed
- f5927da4ff6c 17.8 landed
- 68ebdf2b07f6 18.2 landed
- dc7c77f825d7 19 (unreleased) landed

On Mon, Dec 15, 2025 at 05:48:29PM +0900, Michael Paquier wrote:
> I have done a couple of tests in the CI and locally, and that was
> looking stable.  Attached is the result of what would happen on HEAD,
> where the change in xlogrecovery.c would include the back-branch
> versions.
> 
> Thoughts or comments are welcome.

And done all of that, with the test added to HEAD and a backpatch down
to v14 for the main fix.
--
Michael