Re: [PostgreSQL 10] default of hot_standby should be "on"?

On Wed, Apr 26, 2017 at 9:36 AM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> On 26 April 2017 at 08:30, Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com> wrote:
>
>> Default for hot_standby parameter should be "on" from PostgreSQL 10?
>>
>> In PostgreSQL 10, -w option is default for [pg_ctl start].
>> So in order to start standby we have to setting hot_standby to "on" or
>> start standby with -W option.
>
> Yeah. That's a good reason to change it. I think at this point warm
> standby is clearly the less-used secondary option and hot_standby
> should be default.
>

The idea of changing the default value seems good to me but I'm not
sure it's good idea to change the default value now under the
circumstances where we're focus on stabilization.
Also we should update the document as well.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center