Re: Cannot increase connection limit?

Thank you!

It was indeed 100, and that allowed me to track down that an upgrade had
swapped in another .conf file in an alternative directory.

I did

show all

which showed the path, actually thanks to this mailing list!

Thank you everyone who responded, especially you, Guillaume.

Brad

Guillaume Lelarge wrote:
> Le mercredi 9 décembre 2009 à 12:14:25, Bradley Kieser a écrit :
>
>> 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?
>>
>
> SHOW max_connections;
>
> or
>
> SELECT setting FROM pg_settings WHERE name='max_connections';
>
>
>> 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?
>>
>
> No. But be sure that you don't set it twice or more in the config file. Be
> sure you look at the good one (SHOW config_file; will tell you which one it
> is). Be sure you don't include other config file with the include clause.
>
>
>> c) Are there any situations where PG
>> will ignore my max_connections setting and will just override it with the
>> default 100?
>>
>>
>
> No.
>
>
>