Re: Sorry too many conecctions

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: "Javier Tesis Tolosa Trabajo" <tesispostgres(at)hotmail(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Sorry too many conecctions
Date: 2004-07-21 19:34:16
Message-ID: 71E37EF6B7DCC1499CEA0316A256832801057CC1@loki.wc.globexplorer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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(at)hotmail(dot)com]
Sent: Wed 7/21/2004 8:08 AM
To: pgsql-sql(at)postgresql(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2004-07-21 23:19:59 Re: ? on announcement of 7.5
Previous Message Josh Berkus 2004-07-21 17:25:33 Re: surrogate key or not?