Re: The behavior of CheckRequiredParameterValues()

From: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: The behavior of CheckRequiredParameterValues()
Date: 2014-03-05 19:15:00
Message-ID: CAD21AoCq_-Pm6or5A1A-KoN8pys51LFv8UHaxeA=OMu-xci+Nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 5, 2014 at 5:13 PM, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Wed, Mar 5, 2014 at 12:07 PM, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>> On Wed, Mar 5, 2014 at 2:09 AM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> wrote:
>>
>>>
>>> xlog.c:6177
>>> if (ControlFile->wal_level < WAL_LEVEL_HOT_STANDBY)
>>> ereport(ERROR,
>>> (errmsg("hot standby is not possible because wal_level was not
>>>
>>> So we have to start and stop standby server with changed
>>> wal_level(i.g., hot_standby) if we want to enable hot standby.
>>> In this case, I think that the standby server didn't need to confirm
>>> wal_level value of ControlFile.
>>> I think that it should confirm value which is written in postgreql.conf.
>>>
>>
>> I think checking it from the control file on a standby in recovery
>> means that we should confirm if the *wal_level with which the WAL was
>> generated* is sufficient to now become a hot standby after recovery
>> finishes.
>>
>
> Sorry, should have said:
> *become a hot standby after recovery reaches a consistent state
>

Thank you for explain!
I understood it!

Regards,

-------
Sawada Masahiko

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-03-05 19:22:25 Re: BUG #9223: plperlu result memory leak
Previous Message Josh Berkus 2014-03-05 19:10:52 Re: jsonb and nested hstore