pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Add more LOG messages when starting and ending recovery from a b 3+ messages / 1 participants [nested] [flat]
* pgsql: Add more LOG messages when starting and ending recovery from a b @ 2024-01-25 08:10 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 3+ messages in thread From: Michael Paquier @ 2024-01-25 08:10 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Add more LOG messages when starting and ending recovery from a backup Three LOG messages are added in the recovery code paths, providing information that can be useful to track corruption issues depending on the state of the cluster, telling that: - Recovery has started from a backup_label. - Recovery is restarting from a backup start LSN, without a backup_label. - Recovery has completed from a backup. Author: Andres Freund Reviewed-by: David Steele, Laurenz Albe, Michael Paquier Discussion: https://postgr.es/m/20231117041811.vz4vgkthwjnwp2pp@awork3.anarazel.de Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1d35f705e191581784e9df89bb69b7867ac9c342 Modified Files -------------- src/backend/access/transam/xlogrecovery.c | 34 +++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Add more LOG messages when starting and ending recovery from a b @ 2024-01-29 00:05 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 3+ messages in thread From: Michael Paquier @ 2024-01-29 00:05 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Add more LOG messages when starting and ending recovery from a backup Three LOG messages are added in the recovery code paths, providing information that can be useful to track corruption issues depending on the state of the cluster, telling that: - Recovery has started from a backup_label. - Recovery is restarting from a backup start LSN, without a backup_label. - Recovery has completed from a backup. This was originally applied on HEAD as of 1d35f705e191, and there is consensus that this can be useful for older versions. This applies cleanly down to 15, so do it down to this version for now (older versions have heavily refactored the WAL recovery paths, making the change less straight-forward to do). Author: Andres Freund Reviewed-by: David Steele, Laurenz Albe, Michael Paquier Discussion: https://postgr.es/m/20231117041811.vz4vgkthwjnwp2pp@awork3.anarazel.de Backpatch-through: 15 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/edbd1b41ab5bd4be06dbebb3c60149f7910d7c5c Modified Files -------------- src/backend/access/transam/xlogrecovery.c | 34 +++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Add more LOG messages when starting and ending recovery from a b @ 2024-01-29 00:05 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 3+ messages in thread From: Michael Paquier @ 2024-01-29 00:05 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Add more LOG messages when starting and ending recovery from a backup Three LOG messages are added in the recovery code paths, providing information that can be useful to track corruption issues depending on the state of the cluster, telling that: - Recovery has started from a backup_label. - Recovery is restarting from a backup start LSN, without a backup_label. - Recovery has completed from a backup. This was originally applied on HEAD as of 1d35f705e191, and there is consensus that this can be useful for older versions. This applies cleanly down to 15, so do it down to this version for now (older versions have heavily refactored the WAL recovery paths, making the change less straight-forward to do). Author: Andres Freund Reviewed-by: David Steele, Laurenz Albe, Michael Paquier Discussion: https://postgr.es/m/20231117041811.vz4vgkthwjnwp2pp@awork3.anarazel.de Backpatch-through: 15 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8b34cff3381a6a1d3c3d97141d468d468d2a2551 Modified Files -------------- src/backend/access/transam/xlogrecovery.c | 34 +++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-01-29 00:05 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-01-25 08:10 pgsql: Add more LOG messages when starting and ending recovery from a b Michael Paquier <michael@paquier.xyz> 2024-01-29 00:05 pgsql: Add more LOG messages when starting and ending recovery from a b Michael Paquier <michael@paquier.xyz> 2024-01-29 00:05 pgsql: Add more LOG messages when starting and ending recovery from a b Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox