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.postgresql.org/docs/9.0/static/runtime-config-connection.html)
So in your case, you have 480 connections for super users out of 50 total. Its not that 20 of them are reserved for non-superusers.... so since you have less then 480 connections available, only super users can use them. I don't believe postgresql cares who is currently using a connection... rather if the number of available connections is less then what is set in 'superuser_reserved_connections', only superusers can use it. (Someone can correct me if I'm wrong here)
On Thu, Feb 28, 2013 at 2:17 PM, G B <g.b.coder@xxxxxxxxx> wrote:
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, I only see 62 connections from the super user (postgres) and that number is less than 480.I don't see any connections from non super user. Yet , when I try to login as non super user, it claims it ran out of non super user reserved connections.On Thu, Feb 28, 2013 at 3:49 PM, Chris Angelico <rosuav@xxxxxxxxx> wrote:On Fri, Mar 1, 2013 at 7:38 AM, G B <g.b.coder@xxxxxxxxx> wrote:This leaves just 20 connections for non-root users. Did you intend to
> SHOW superuser_reserved_connections;
>
> 480
>
> SHOW max_connections;
> 500
>
> Is there something I'm missing here? Thanks for your help.
set superuser_reserved_connections to 20, thus leaving 480 for normal
use?
ChrisA
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Virtually, Ned Wolpert
"Settle thy studies, Faustus, and begin..." --Marlowe
