Thread: Sorry too many conecctions

Sorry too many conecctions

From
"Javier Tesis Tolosa Trabajo"
Date:
hi everybody
I speak english a little,Sorry.

I have A problem whith de connections from a Aplicatio Java, guive  me a 
Error "Sorry too many clients",I think what is becuase I don't close 
connecction to the DB postgresql, I do aprox. 1000 conecction into statement 
"while" What can Do?
thakns

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.latam.msn.com/



Re: Sorry too many conecctions

From
"Gregory S. Williamson"
Date:
In the root directory in which postgres stores the data is a file:

postgresql.conf

Edit the file with a text editor (vi / ed / etc.) and change :

max_connections = ###
to
max_connections = 1000(or more since other applications or a DBA may need to connect as well)

and also change

shared_buffers = ###to be at least (max_connections * 2), so change this to at least 2000 for 1000 simulataneous
connections.More connections use more shared memory so you want to have some limits to the total number. 

Save the file changes.

Stop and restart the postgres instance (reload doesn't work for these settings).

Hope this helps,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:    Javier Tesis Tolosa Trabajo [mailto:tesispostgres@hotmail.com]
Sent:    Wed 7/21/2004 8:08 AM
To:    pgsql-sql@postgresql.org
Cc:
Subject:    [SQL] Sorry too many conecctions
hi everybody
I speak english a little,Sorry.

I have A problem whith de connections from a Aplicatio Java, guive  me a
Error "Sorry too many clients",I think what is becuase I don't close
connecction to the DB postgresql, I do aprox. 1000 conecction into statement
"while" What can Do?
thakns

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster