pgsql: pg_rewind: fsync target data directory.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема pgsql: pg_rewind: fsync target data directory.
Дата
Msg-id E1akIal-00066J-3O@gemulon.postgresql.org
обсуждение исходный текст
Список 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
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/c5b5168cfc5c7aa74ce95ef64b79c6633230f424

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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: pgsql: Fix LWLockReportWaitEnd() parameter list to be (void).
Следующее
От: Andres Freund
Дата:
Сообщение: pgsql: pg_rewind: fsync target data directory.