pgsql: Add recovery test for missing redo segment with backup_label

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add recovery test for missing redo segment with backup_label
Date: 2026-07-13 23:16:23
Message-ID: E1wjPss-000452-2e@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add recovery test for missing redo segment with backup_label

This commit adds a test case for early startup where a backup_label file
uses a checkpoint LSN and a redo LSN located in two different segments,
where the segment of the redo LSN is missing. This code has never been
covered, and is complex enough that a test case is going to be useful in
the long-term.

Nitin has proposed a more complex approach than what is added by this
commit, by forcing a reuse of the injection points to produce a split
between redo and checkpoint. This commit relies on the checkpoint and
redo LSNs generated by the first steps of the test, combined with a
generated backup_label, making the whole cheaper.

Author: Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)com>
Author: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/CAMm1aWZ9Tv=Wrx52_2Ppw+6ULf_twRZuQm=ZWLA_a-kXWykHkQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8f71f64deee6747ad9dea18819018b25424d61e5

Modified Files
--------------
src/test/recovery/t/050_redo_segment_missing.pl | 44 +++++++++++++++++++++++++
1 file changed, 44 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2026-07-14 08:40:25 pgsql: Replace __builtin_types_compatible_p with _Generic
Previous Message Jelte Fennema-Nio 2026-07-13 21:43:27 Re: pgsql: Update FSM after updating VM on-access