From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Sync PG_VERSION file in CREATE DATABASE. |
Date: | 2024-02-01 21:46:30 |
Message-ID: | E1rVetC-004Dfc-Lt@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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
Branch
------
REL_15_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/8fa4a1ac61189efffb8b851ee77e1bc87360c445
Modified Files
--------------
doc/src/sgml/monitoring.sgml | 5 +++++
src/backend/commands/dbcommands.c | 8 ++++++++
src/backend/utils/activity/wait_event.c | 3 +++
src/include/utils/wait_event.h | 3 ++-
4 files changed, 18 insertions(+), 1 deletion(-)
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2024-02-02 11:20:45 | pgsql: Allow Gather Merge in more cases for parallel DISTINCT |
Previous Message | Tom Lane | 2024-02-01 20:58:10 | pgsql: Update time zone data files to tzdata release 2024a. |