Sync PG_VERSION file in CREATE DATABASE.
authorNoah Misch <noah@leadboat.com>
Thu, 1 Feb 2024 21:44:19 +0000 (13:44 -0800)
committerNoah Misch <noah@leadboat.com>
Thu, 1 Feb 2024 21:44:19 +0000 (13:44 -0800)
commit0b6517a3b79ae02fb95731d8b1dc70b10cf7b532
tree754ecf65da21b00cf07aeb378070b62540ae0689
parentdf220714e50f2e924c57f4a8d9f578cf6c92a73f
Sync PG_VERSION file in CREATE DATABASE.

An OS crash could leave PG_VERSION empty or missing.  The same symptom
appeared in a backup by block device snapshot, taken after the next
checkpoint and before the OS flushes the PG_VERSION blocks.  Device
snapshots are not a documented backup method, however.  Back-patch to
v15, where commit 9c08aea6a3090a396be334cc58c511edab05776a introduced
STRATEGY=WAL_LOG and made it the default.

Discussion: https://postgr.es/m/20240130195003.0a.nmisch@google.com
src/backend/commands/dbcommands.c
src/backend/utils/activity/wait_event_names.txt