Обсуждение: pgsql: Keep CommitTs module in sync in standby and master

Поиск
Список
Период
Сортировка

pgsql: Keep CommitTs module in sync in standby and master

От
Alvaro Herrera
Дата:
Keep CommitTs module in sync in standby and master

We allow this module to be turned off on restarts, so a restart time
check is enough to activate or deactivate the module; however, if there
is a standby replaying WAL emitted from a master which is restarted, but
the standby isn't, the state in the standby becomes inconsistent and can
easily be crashed.

Fix by activating and deactivating the module during WAL replay on
parameter change as well as on system start.

Problem reported by Fujii Masao in
http://www.postgresql.org/message-id/CAHGQGwFhJ3CnHo1CELEfay18yg_RA-XZT-7D8NuWUoYSZ90r4Q@mail.gmail.com

Author: Petr Jelínek

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4f3924d9cd438ba4e6fd639460f8c859c65d45a3

Modified Files
--------------
src/backend/access/transam/commit_ts.c |   81 +++++++++++++++++++++++---------
src/backend/access/transam/xlog.c      |   36 +++++++++++++-
src/backend/commands/vacuum.c          |    2 +-
src/include/access/commit_ts.h         |    4 +-
4 files changed, 99 insertions(+), 24 deletions(-)