Re: Use of backup_label not noted in log

From: David Steele <david(at)pgmasters(dot)net>
To: Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Subject: Re: Use of backup_label not noted in log
Date: 2024-01-19 13:32:26
Message-ID: f630fb76-c1f2-4517-9f88-c7a8bb0078ca@pgmasters.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/20/23 15:08, David Steele wrote:
> On 11/20/23 14:27, Andres Freund wrote:
>
>>>> I've wondered whether it's worth also adding an explicit message
>>>> just after
>>>> ReachedEndOfBackup(), but it seems far less urgent due to the existing
>>>> "consistent recovery state reached at %X/%X" message.
>>>
>>> I think the current message is sufficient, but what do you have in mind?
>>
>> Well, the consistency message is emitted after every restart. Whereas
>> a single
>> instance only should go through backup recovery once. So it seems
>> worthwhile
>> to differentiate the two in log messages.
>
> Ah, right. That works for me, then.

Any status on this patch? If we do back patch it would be nice to see
this in the upcoming minor releases. I'm in favor of a back patch, as I
think this is minimally invasive and would be very useful for debugging
recovery issues.

I like the phrasing you demonstrated in [1] but doesn't seem like
there's a new patch for that, so I have attached one.

Happy to do whatever else I can to get this across the line.

Regards,
-David

---

[1]
https://www.postgresql.org/message-id/20231120183633.c4lhoq4hld4u56dd%40awork3.anarazel.de

Attachment Content-Type Size
v3-0001-WIP-Log-when-starting-up-from-a-base-backup.patch text/plain 2.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2024-01-19 14:00:00 Re: BUG: Former primary node might stuck when started as a standby
Previous Message Alexander Korotkov 2024-01-19 13:27:18 Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)