Add checkpoint/redo LSNs to recovery errors.

From: David Steele <david(at)pgmasters(dot)net>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Add checkpoint/redo LSNs to recovery errors.
Date: 2024-02-28 21:53:15
Message-ID: 0e90da89-77ca-4ccf-872c-9626d755e288@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

This patch adds checkpoint/redo LSNs to recovery error messages where
they may be useful for debugging.

When backup_label is present the LSNs are already output in a log
message, but it still seems like a good idea to repeat them.

When backup_label is not present, the checkpoint LSN is not logged
unless backup recovery is in progress or the checkpoint is found. In the
case where a backup is restored but the backup_label is missing, the
checkpoint LSN is not logged so it is useful for debugging to have it in
the error message.

Regards,
-David

Attachment Content-Type Size
add-lsn-to-err-v1.patch text/plain 2.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-02-28 22:23:22 Re: Relation bulk write facility
Previous Message Daniel Gustafsson 2024-02-28 21:52:40 Re: [PoC] Federated Authn/z with OAUTHBEARER