]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 6d423e9) | 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:22 +0000 (13:44 -0800)
commit48a6bf5c4ea8e04cc9bb33a8120a21743da515ed
tree246b87c17f1efd2cb11c0cd8269bf475d4c261c8tree | snapshot
parent6d423e9ff95ac2e62655faa97633155d08dfdd64commit | 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
Mirror of https://git.postgresql.org/git/postgresql.git