pgsql: Recursively fsync() the data directory after a crash. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Recursively fsync() the data directory after a crash.
Date
Msg-id E1YpL1A-0007Tz-Av@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Recursively fsync() the data directory after a crash.  (Andrew Dunstan <andrew@dunslane.net>)
Re: pgsql: Recursively fsync() the data directory after a crash.  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-committers
Recursively fsync() the data directory after a crash.

Otherwise, if there's another crash, some writes from after the first
crash might make it to disk while writes from before the crash fail
to make it to disk.  This could lead to data corruption.

Back-patch to all supported versions.

Abhijit Menon-Sen, reviewed by Andres Freund and slightly revised
by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2ce439f3379aed857517c8ce207485655000fc8e

Modified Files
--------------
src/backend/access/transam/xlog.c |   42 ++++++++++++++
src/backend/storage/file/fd.c     |  115 +++++++++++++++++++++++++++++++++++++
src/include/storage/fd.h          |    2 +
3 files changed, 159 insertions(+)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Recursively fsync() the data directory after a crash.
Next
From: Robert Haas
Date:
Subject: pgsql: Recursively fsync() the data directory after a crash.