Horton

Sync PG_VERSION file in CREATE DATABASE.

Noah Misch <noah@leadboat.com>

View on postgr.es
Commit: 0b6517a3b79ae02fb95731d8b1dc70b10cf7b532
Author: Noah Misch <noah@leadboat.com>
Date: 2024-02-01T21:44:19Z
Releases: 17.0 
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

Files

PathChange+/−
src/backend/commands/dbcommands.c modified +8 −0
src/backend/utils/activity/wait_event_names.txt modified +1 −0

Discussion