pgsql: pg_rewind: fsync target data directory. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: pg_rewind: fsync target data directory.
Date
Msg-id E1akIai-00065w-VV@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pg_rewind: fsync target data directory.

Previously pg_rewind did not fsync any files. That's problematic, given
that the target directory is modified. If the database was started
afterwards, 2ce439f33 luckily already caused the data directory to be
synced to disk at postmaster startup; reducing the scope of the problem.

To fix, use initdb -S, at the end of the pg_rewind run. It doesn't seem
worthwhile to duplicate the code into pg_rewind, and initdb -S is
already used that way by pg_upgrade.

Reported-By: Andres Freund
Author: Michael Paquier, somewhat edited by me
Discussion: 20160310034352.iuqgvpmg5qmnxtkz@alap3.anarazel.de
    CAB7nPqSytVG1o4S3S2pA1O=692ekurJ+fckW2PywEG3sNw54Ow@mail.gmail.com
Backpatch: 9.5, where pg_rewind was introduced

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/408f0438531eec17ac62f91fc23f72bcfc48dd36

Modified Files
--------------
src/bin/pg_rewind/file_ops.c  |  1 -
src/bin/pg_rewind/pg_rewind.c | 57 +++++++++++++++++++++++++++++++++++++++++++
2 files changed, 57 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: pg_rewind: fsync target data directory.
Next
From: Tom Lane
Date:
Subject: pgsql: Clamp adjusted ndistinct to positive integer in estimate_hash_bu