Re: Logging WAL when updating hintbit

From: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Logging WAL when updating hintbit
Date: 2013-12-03 06:30:13
Message-ID: CAD21AoCfvtSOCGhSxDcq=E=cXf-CANSD_06vYcP8H4Xzac-Tjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 3, 2013 at 12:02 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> On Tue, Dec 3, 2013 at 11:57 AM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
>> On Tue, Dec 3, 2013 at 1:08 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>> Forcing it to be done only an initdb-time is excessive. I think you
>>> can just make it PGC_POSTMASTER and have it participate in the
>>> XLOG_PARAMETER_CHANGE mechanism. pg_rewind can check that it's set in
>>> the control file before agreeing to rewind.

Yep, I will modify it.

>> Indeed, I forgot this code path. Completing XLogReportParameters for
>> saving the state and xlog_redo for replay would be enough.
> Wait a minute, I retract this argument. By using this method a master
> server would be able to produce WAL files with inconsistent hint bit
> data when they are replayed if log_hint_bits is changed after a
> restart of the master.

How case does it occur?
I think pg_rewind can disagree to rewind if log_hint_bits is changed to 'OFF'.
Is this not enough?

Regards,

-------
Sawada Masahiko

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2013-12-03 06:31:56 Re: Extension Templates S03E11
Previous Message Noah Misch 2013-12-03 06:18:36 Re: note to reviewers: reply to the original email