Secondly, 5 users can still manage to make multiple connections. You can use ps to see how many connections are active at any given time.
http://www.postgresql.org/docs/8.0/static/monitoring.html#MONITORING-PS
-tfo
-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
On Mar 7, 2005, at 7:08 AM, ganapatiram wrote:
Hi Experts,
I work with postgresql 8.0 version. I have a team of 14 developers. When all the team connects the DB i see this error very very frequently which is a severe problem for me and team all the day. The error is:
Please report this exception: java.sql.SQLException: FATAL: sorry, too many clients already
when i do trial and error changes i see this error differently but the essense of the error remains same.
I have max_connections=200 and i have 5 users for my DB. I dont understand what to do in order to resolve this. Please suggest me something by which i can overcome this problem. I referred few threads but none of them are of my case.
Waiting for your valuable suggestion..........
Thanks and Regards
Ram
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
