superuser_reserved_connections and max_connections

From: Travis Kirstine <tkirstine(at)firstbasesolutions(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: superuser_reserved_connections and max_connections
Date: 2016-06-24 16:10:41
Message-ID: 1466784642535.32585@firstbasesolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


We were getting a lot of "max connections reached" errors and noticed that all our users are super users, after some digging I found the

superuser_reserved_connections parameter was not set (default to 3) this lead to some additional questions:

If all my users are superusers are they effectively limited to the number of connections defined in the

superuser_reserved_connections parameter?

Is there any significant difference between a superuser and non-superuser connection?

Any additional insight would be great.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2016-06-24 16:26:10 Re: superuser_reserved_connections and max_connections
Previous Message Albe Laurenz 2016-06-24 11:57:42 Re: PostgreSQL version upgrade from 9.1 to 9.5