>From the docs:
"superuser_reserved_connections: Whenever the number of active concurrent
connections is at least max_connections minus
superuser_reserved_connections, new connections will be accepted only for
superusers, and no new replication connections will be accepted." (
http://www.postgresq
My intention was to have 480 max connections for super user and 20
connections for non super user. (I created the non super user account for
an external user to log into PgAdmin and look at the schema) Is there a
problem with 20 connections in such a scenario?
When I select from pg_stat_activity
On Fri, Mar 1, 2013 at 7:38 AM, G B wrote:
> SHOW superuser_reserved_connections;
>
> 480
>
> SHOW max_connections;
> 500
>
> Is there something I'm missing here? Thanks for your help.
This leaves just 20 connections for non-root users. Did you intend to
set superuser_reserved_connections
We have a number of applications using a production database under a super
user account. I've created a new (non-super) user account and if I try to
login using this account I get the
"Non-superuser connection limit exceeded" error. I'm aware of the
postgresql.conf settings for max user connections