| From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | connection limit exceeded |
| Date: | 2007-11-30 19:55:49 |
| Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C03062DED@egcrc-ex01.egcrc.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Everybody,
On my postgres 8.1.1, I get a response
psql: FATAL: connection limit exceeded for non-superusers
A few questions come to mind...
1) Is this to do with max_connections setting in the postgres
configuration file? (my setting is 100 (I think this is the
default).)
2) how would I look at the "open/used" connections?
3) should I try restarting postgres without changing the setting?
4) what repercussion would there be if I increase this number to,
say, 200? (and would that be a good idea?)
5) finally, what's the best fix? (Do I need to go to pgpool?)
Many thanks in advance.
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2007-11-30 20:03:31 | Re: connection limit exceeded |
| Previous Message | Campbell, Lance | 2007-11-30 19:46:53 | Enhancement request |