Re: The behavior of CheckRequiredParameterValues() - Mailing list pgsql-hackers

From Amit Langote
Subject Re: The behavior of CheckRequiredParameterValues()
Date
Msg-id CA+HiwqF14KN3CwewK-2YQSubiqZxtq82LegQ_bWPsTvqRtGbNA@mail.gmail.com
Whole thread Raw
In response to Re: The behavior of CheckRequiredParameterValues()  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: The behavior of CheckRequiredParameterValues()  (Sawada Masahiko <sawada.mshk@gmail.com>)
List pgsql-hackers
On Wed, Mar 5, 2014 at 12:07 PM, Amit Langote <amitlangote09@gmail.com> wrote:
> On Wed, Mar 5, 2014 at 2:09 AM, Sawada Masahiko <sawada.mshk@gmail.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

--
Amit



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Trigger information for auto_explain.
Next
From: Kouhei Kaigai
Date:
Subject: Re: Custom Scan APIs (Re: Custom Plan node)