Re: superuser_reserved_connections and max_connections

Ummm.... YES, there are great (potential) differences between non-Superuser
and Superuser connections and their abilities. Apparently when your users
were created, someone added superuser abilities to each one. That is almost
certainly an error. You may have users which should have read-only ability
others who should have read-write, and far fewer with superuser. Check the
web pages for GRANTS as to what each user can have. If you have lots of
users and don't want to assign each individually, then make a group role,
give it the abilities you want, then assign your appropriate users to that
group. Sounds like you need to read up on database security.
--
Jay

On Fri, Jun 24, 2016 at 11:10 AM, Travis Kirstine <
tkirstine(at)firstbasesolutions(dot)com> wrote:

>
> 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.
>