Thread: max connection limit

max connection limit

From
"Mario Alberto Soto Cordones"
Date:
Hi, i have a big problem...

I need more to 32 connections but postgres only work with 32 connections.
HOW INCREASE THIS PARAMETER ?????

I need almost 200 connections.

Thank you

Mario


Re: max connection limit

From
Date:

Its easy ,

just bump off the max_connections  variable
in postgresql.conf file located in
/var/lib/pgsql/data or /usr/local/pgsql/data/

depending on installation.

regds

mallah.




> Hi, i have a big problem...
>
> I need more to 32 connections but postgres only work with 32 connections. HOW INCREASE THIS
> PARAMETER ?????
>
> I need almost 200 connections.
>
> Thank you
>
> Mario
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you
> checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html



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


Re: max connection limit

From
Date:

I
I think u are not restarting the server
after making the changes.

do
/etc/rc.d/init.d/postgresql restart

after making the chages.


> Hi Mallah.
>
> in my configuration put
>
> 32, 64 90, 100, etc.
>
> but only take to 32 connections not more
> i know this becose make a test with the connectio´ns.
>
> Mario
>
>> Hi,
>>
>> see this is how its configured in my server.
>> do something similar , its trivial.
>> u must reload the config file after changes
>> though , hope u getting me.
>> and if u get error please post the error
>>
>>
>> tcpip_socket = true
>> #ssl = false
>>
>> max_connections = 64
>> superuser_reserved_connections = 2
>>
>>
>>> Ok.
>>> i comment this line but when try connect say error... when uncommnet this line work good
>>>
>>> what can do
>>> thank
>>>
>>>>
>>>>
>>>> Its easy ,
>>>>
>>>> just bump off the max_connections  variable
>>>> in postgresql.conf file located in
>>>> /var/lib/pgsql/data or /usr/local/pgsql/data/
>>>>
>>>> depending on installation.
>>>>
>>>> regds
>>>>
>>>> mallah.
>>>>
>>>>
>>>>
>>>>
>>>>> Hi, i have a big problem...
>>>>>
>>>>> I need more to 32 connections but postgres only work with 32
>>>>> connections. HOW INCREASE THIS PARAMETER ?????
>>>>>
>>>>> I need almost 200 connections.
>>>>>
>>>>> Thank you
>>>>>
>>>>> Mario
>>>>>
>>>>>
>>>>> ---------------------------(end of
>>>>> broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
>>>>>
>>>>> http://www.postgresql.org/docs/faqs/FAQ.html
>>>>
>>>>
>>>>
>>>> -----------------------------------------
>>>> Get your free web based email at trade-india.com.
>>>>    "India's Leading B2B eMarketplace.!"
>>>> http://www.trade-india.com/
>>>
>>>
>>> --
>>>   Mario Soto Cordones
>>>  Gerente de Proyectos
>>> Compuall Ingeniería Ltda.
>>
>>
>>
>> -----------------------------------------
>> Get your free web based email at trade-india.com.
>>    "India's Leading B2B eMarketplace.!"
>> http://www.trade-india.com/
>
>
> --
>   Mario Soto Cordones
>  Gerente de Proyectos
> Compuall Ingeniería Ltda.



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