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