Re: Use of backup_label not noted in log
David Steele <david@pgmasters.net>
From: David Steele <david@pgmasters.net>
To: Andres Freund <andres@anarazel.de>,
Pg Hackers <pgsql-hackers@postgresql.org>,
Michael Paquier <michael@paquier.xyz>,
Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2023-11-20T19:08:15Z
Lists: pgsql-hackers
On 11/20/23 14:27, Andres Freund wrote: > Hi, > > On 2023-11-19 14:28:12 -0400, David Steele wrote: >> On 11/18/23 17:49, Andres Freund wrote: >>> On 2023-11-18 10:01:42 -0800, Andres Freund wrote: >>> Not enamored with the phrasing of the log messages, but here's a prototype: >>> >>> When starting up with backup_label present: >>> LOG: starting from base backup with redo LSN A/34100028, checkpoint LSN A/34100080 on timeline ID 1 >> >> I'd prefer something like: >> >> LOG: starting backup recovery with redo... > >>> When restarting before reaching the end of the backup, but after backup_label >>> has been removed: >>> LOG: continuing to start from base backup with redo LSN A/34100028 >>> LOG: entering standby mode >>> LOG: redo starts at A/3954B958 >> >> And here: >> >> LOG: restarting backup recovery with redo... > > I like it. Cool. >>> 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. Regards, -David
Commits
-
Add more LOG messages when starting and ending recovery from a backup
- 8b34cff3381a 15.6 landed
- edbd1b41ab5b 16.2 landed
- 1d35f705e191 17.0 landed