Horton

Acquire ControlFileLock in relevant SQL functions.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: c558e6fd92ffeb85d5f52e32ccbcf8a5b5eb7bf3
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2023-10-15T21:43:47Z
Releases: 17.0 
Acquire ControlFileLock in relevant SQL functions.

Commit dc7d70ea added functions that read the control file, but didn't
acquire ControlFileLock.  With unlucky timing, file systems that have
weak interlocking like ext4 and ntfs could expose partially overwritten
contents, and the checksum would fail.

Back-patch to all supported releases.

Reviewed-by: David Steele <david@pgmasters.net>
Reviewed-by: Anton A. Melnikov <aamelnikov@inbox.ru>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/20221123014224.xisi44byq3cf5psi%40awork3.anarazel.de

Files

PathChange+/−
src/backend/utils/misc/pg_controldata.c modified +9 −0

Discussion