Cannot increase connection limit?

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

Responses

Browse pgsql-admin by date

  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