Re: MAX CONNECTIONS PROBLEM

Поиск
Список
Период
Сортировка
От
Тема Re: MAX CONNECTIONS PROBLEM
Дата
Msg-id 1298.219.65.254.25.1051301358.squirrel@mail.trade-india.com
обсуждение исходный текст
Ответ на Re: MAX CONNECTIONS PROBLEM  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-admin
>> > > Hi all. i have a big problem with the max-connections parameter.
>> > >
>> > > the default it?s 32 but i increase to 200. shutdown the machine and restart, but nothing.
>> >
>> > I suspect you need to reconfigure your kernel.
>>
>> reconfigure kernel ??
>> why you think so
>
> Lack of shared memory allocated, limits being too low, etc.  Can be any one of a number of
> reasons but those are the most likely in this case.


Actually his problem is solved he kindly allowed me to login
and examine.

The problem was hiz shared_buffers were 64 and we wanted
max_connections to be 200 so shared_buffers were falling short.
the postmaster was ritely complaining ,  but the brain dead RPM packages
put  redirect messages to  /dev/null

:(

regds
mallah.





>
> -sc
>
> --
> Sean Chittenden



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/


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

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: MAX CONNECTIONS PROBLEM
Следующее
От: Kris Kiger
Дата:
Сообщение: Problem restoring a table from 7.2.1 to 7.3.2