| From: | Bradley Kieser <brad(at)kieser(dot)net> |
|---|---|
| To: | PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Cannot increase connection limit? |
| Date: | 2009-12-09 11:14:25 |
| Message-ID: | 4B1F8691.7090403@kieser.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
I have been struggling with my Posgres installation. I frequently get
connection limit exceeded for non-superusers
errors. I have checked the process count and it seems to be a limit of 100 connections.
However, I have already set
max_connections = 250
in my postgresql.conf and restarted the server.
I have checked pg_authid and the rolconnlimit value is set to -1 for all users, so should have no limits.
So this seems to be some sort of limit overriding my max_connections settings.
I am running on RH EL5 and have PG 8.3.8
Can someone please point me in the right direction here?
a) Is there some way of getting the LIVE max_connections setting from the server? I.e. So that I can check if the running server has max_connections set to 100 when I am expecting it to be 250?
b) Are there any other places that max_connections can be set other than the conf file? I.e. where else should I look for this to be set?
c) Are there any situations where PG will ignore my max_connections setting and will just override it with the default 100?
Thanks,
Brad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2009-12-09 12:19:42 | Re: Cannot increase connection limit? |
| Previous Message | Rodrigo Hjort | 2009-12-08 13:35:58 | Re: PostgreSQL monitoring |