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:23 -0800 |
| commit | 8fa4a1ac61189efffb8b851ee77e1bc87360c445 (patch) | |
| tree | 0d6cf5c6495cd17aedd0d2e9e31bcededd740ad6 /doc/src | |
| parent | d493bed28f7f6c77051bba3dde383e0ff78d3a19 (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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index c72ad60fa0e..84e65002ff3 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1520,6 +1520,11 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <entry>Waiting for a write of a two phase state file.</entry> </row> <row> + <entry><literal>VersionFileSync</literal></entry> + <entry>Waiting for the version file to reach durable storage while + creating a database.</entry> + </row> + <row> <entry><literal>VersionFileWrite</literal></entry> <entry>Waiting for the version file to be written while creating a database.</entry> </row> |