diff options
| author | Noah Misch <noah@leadboat.com> | 2024-02-01 13:44:19 -0800 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2024-02-01 13:44:19 -0800 |
| commit | 0b6517a3b79ae02fb95731d8b1dc70b10cf7b532 (patch) | |
| tree | 754ecf65da21b00cf07aeb378070b62540ae0689 /src/backend/utils | |
| parent | df220714e50f2e924c57f4a8d9f578cf6c92a73f (diff) | |
| download | postgresql-0b6517a3b79ae02fb95731d8b1dc70b10cf7b532.tar.gz postgresql-0b6517a3b79ae02fb95731d8b1dc70b10cf7b532.zip | |
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
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/activity/wait_event_names.txt | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backend/utils/activity/wait_event_names.txt b/src/backend/utils/activity/wait_event_names.txt index cd22dca7021..6464386b779 100644 --- a/src/backend/utils/activity/wait_event_names.txt +++ b/src/backend/utils/activity/wait_event_names.txt @@ -236,6 +236,7 @@ TIMELINE_HISTORY_WRITE "Waiting for a write of a newly created timeline history TWOPHASE_FILE_READ "Waiting for a read of a two phase state file." TWOPHASE_FILE_SYNC "Waiting for a two phase state file to reach durable storage." TWOPHASE_FILE_WRITE "Waiting for a write of a two phase state file." +VERSION_FILE_SYNC "Waiting for the version file to reach durable storage while creating a database." VERSION_FILE_WRITE "Waiting for the version file to be written while creating a database." WALSENDER_TIMELINE_HISTORY_READ "Waiting for a read from a timeline history file during a walsender timeline command." WAL_BOOTSTRAP_SYNC "Waiting for WAL to reach durable storage during bootstrapping." |