Re: max connection limit - Mailing list pgsql-admin

From
Subject Re: max connection limit
Date
Msg-id 1100.219.65.253.239.1050943004.squirrel@mail.trade-india.com
Whole thread Raw
In response to max connection limit  ("Mario Alberto Soto Cordones" <mario_soto@compuall.cl>)
List pgsql-admin

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/


pgsql-admin by date:

Previous
From:
Date:
Subject: Re: max connection limit
Next
From: "John M. Layman"
Date:
Subject: trouble migrating large objects from 7.1.3 to 7.3.2