Re: Server won't start with fallback setting by initdb.

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: Server won't start with fallback setting by initdb.
Дата
Msg-id
20180212132815.GB18625@paquier.xyz
Ответ на
Список
Дерево обсуждения
Server won't start with fallback setting by initdb. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Stephen Frost <sfrost@snowman.net>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
On Fri, Feb 09, 2018 at 05:08:23PM +0900, Kyotaro HORIGUCHI wrote:
> > postgres: max_wal_senders must be less than max_connections
> 
> I think that we can safely increase the fallback value to 20 with
> which regtests are known not to fail. I believe that is
> preferable than explicitly reducing max_wal_senders in the
> generated config file. I confirmed that tegtest won't fail with
> the value. (Except with permanent failure of dynamic shared
> memory)

I would vote for just removing the minimum check at 10 connections as
you do.  It is not worth the code complication in initdb to decrease
max_wal_senders if max_connections is set to 10, which does not happen
even on definitely-not-decent hardware of those days like a RPI
(memories from my hamster, RIP, which set max_connections to 100). 
--
Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Peter Eisentraut
Дата:
FAQ