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

From: Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com>
Subject: [PostgreSQL 10] default of hot_standby should be "on"?
Date: 2017-04-26 00:30:21
Message-ID: 75DB81BEEA95B445AE6D576A0A5C9E936A624B38@BPXM05GP.gisp.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

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.

Change hot_standby to "on" will fix this inconvenience.
wal_level is also changed default to "replica" in PostgreSQL 10,
this might not be affect to primary.

Just a little bit but I attached the patch.
---
Thanks and best regards,
Dang Minh Huong
NEC Solution Innovators, Ltd.
http://www.nec-solutioninnovators.co.jp/en/

Attachment Content-Type Size
hot_standby.patch application/octet-stream 909 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2017-04-26 00:36:31 Re: [PostgreSQL 10] default of hot_standby should be "on"?
Previous Message Tsunakawa, Takayuki 2017-04-26 00:26:33 Re: PG 10 release notes