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: | Raw Message | Whole Thread | 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 |