Re: remove wal_level archive

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: remove wal_level archive
Дата
Msg-id CAB7nPqQ=2+uv9U3FM0Yvkf0umAG9KO7MXN01ghjah_owCKUXFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: remove wal_level archive  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: remove wal_level archive
Список pgsql-hackers
On Mon, Nov 2, 2015 at 2:21 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
> On 1 September 2015 at 10:39, Peter Eisentraut <peter_e@gmx.net> wrote:
>> So we've had several rounds of discussions about simplifying replication
>> configuration in general and the wal_level setting in particular. [0][1]
>>
>> [snip]
>>
>> Bike-shedding:  In this patch, I removed "archive" and kept
>> "hot_standby", because that's what the previous discussions suggested.
>> Historically and semantically, it would be more correct the other way
>> around.  On the other hand, keeping "hot_standby" would probably require
>> fewer configuration files to be changed.  Or we could keep both, but
>> that would be confusing (for users and in the code).
>
> We need to keep both, IMO, with 'archive' as an obsolete synonym for
> hot_standby.
>
> Otherwise pg_upgrade will get grumpy, and so will users who migrate
> their configurations.

pg_upgradecluster has some logic to switch a parameter value (see
strrepl), and pg_upgrade does not handle parameter name switches by
itself, so the price to pay would be more maintenance annoyance for
existing upgrade scripts, which happens at more or less each major
release (checkpoint_segments removed in 9.5, unix_socket_directory
renamed in 9.3, etc.).
-- 
Michael



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service