max connection limit
max connection limit
От:
"Mario Alberto Soto Cordones" <mario_soto@compuall.cl>
Дата:
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
От:
<mallah@trade-india.com>
Дата:
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
От:
<mallah@trade-india.com>
Дата:
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/