pgsql: Keep CommitTs module in sync in standby and master

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Keep CommitTs module in sync in standby and master
Date: 2015-03-09 20:44:41
Message-ID: E1YV4XZ-00053B-Jq@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2015-03-10 15:12:38 pgsql: Allow named parameters to be specified using => in addition to :
Previous Message Alvaro Herrera 2015-03-09 20:03:33 pgsql: Fix crasher bugs in previous commit