Cannot restart postgresql when increasing max_connections

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Cannot restart postgresql when increasing max_connections
Дата
Msg-id bddc86150901080244y11be37aanaa4495989946f1ae@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cannot restart postgresql when increasing max_connections
Список pgsql-general
Hi,

I have a server running 8.3.1 with 16Gb of memory and 8x2.5Ghz cores.  The max_connections was set to 100 (the default), but we were getting denied connections because it had exceeded the max.  We increased this to a modest 250, stopped the service, and then tried to start.  It wouldn't.  We stopped it several times, made sure all postgres-related processes were killed off but nothing would make it start.  Actually, it said it had started, but it hadn't.  When setting it back to 100 it was okay again.  We tried the same thing on another server, setting it to 1000, and that was fine.

Am I missing something?

Thom

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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: RCA for MemoryContextAlloc: invalid request size(Known Issue)
Следующее
От: Mohamed
Дата:
Сообщение: Re: Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..