projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d493bed) | patch
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:23 +0000 (13:44 -0800)
commit8fa4a1ac61189efffb8b851ee77e1bc87360c445
tree0d6cf5c6495cd17aedd0d2e9e31bcededd740ad6tree
parentd493bed28f7f6c77051bba3dde383e0ff78d3a19commit | diff
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
doc/src/sgml/monitoring.sgml diff | blob | blame | history
src/backend/commands/dbcommands.c diff | blob | blame | history
src/backend/utils/activity/wait_event.c diff | blob | blame | history
src/include/utils/wait_event.h diff | blob | blame | history
This is the main PostgreSQL git repository.