model-writtenrun 4708 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Ryo Matsumura reported that DDL changes to a template database could disappear after a checkpoint and crash because CREATE DATABASE with WAL_LOG loaded pg_class buffers without marking them permanent #1, and Justin Pryzby independently reproduced the failure #2.
- Nathan Bossart supplied a one-line fix marking those buffers permanent because pg_class is a logged relation #3, and Dilip Kumar confirmed that the fix addressed the issue #4.
- Michael Paquier requested regression coverage and expressed concern about WAL_LOG having become the default immediately #5; Nathan added a TAP test that failed before the fix and passed afterward #6.
- Robert Haas and Michael Paquier explained why the new test needed Meson registration #8 #9, while discussion of the generic test name prompted Michael to recommend a CREATE DATABASE-specific recovery test #15, which Nathan adopted in #17.
- Michael extended the test to inspect the copied database and exercise a crash without a checkpoint #18, but Nathan questioned the value of the latter scenario while finding the rest reasonable #19.
- Michael committed 8a8661828a from #18, retaining the unchanged backend fix and refined checkpoint test while dropping the additional scenario as unnecessary test cycles; he reported applying and backpatching the fix to PostgreSQL 15 in #20.
- The thread closed with Nathan's thanks #21, with the fix landed and no further patch work outstanding.