bhargav kamineni <bhargavpostg...@gmail.com> writes:
> Postgres was rejecting a bunch of connections from a user who is having a
> connection limit set. that was the the FATAL error that i could see in log
> file.
>  FATAL,53300,"too many connections for role ""user_app"""

> db=\du user_app
>                            List of roles
>   Role name   |          Attributes           |     Member of
> --------------+-------------------------------+--------------------
>  user_app | No inheritance               +| {application_role}
>               | 100 connections              +|
>               | Password valid until infinity |

>Hm, what's the overall max_connections limit?  (I'm wondering
in particular if it's more or less than 100.)

its set to 500;
show max_connections ;
 max_connections
-----------------
 500


On Thu, 3 Oct 2019 at 22:52, Tom Lane <t...@sss.pgh.pa.us> wrote:

> bhargav kamineni <bhargavpostg...@gmail.com> writes:
> > Postgres was rejecting a bunch of connections from a user who is having a
> > connection limit set. that was the the FATAL error that i could see in
> log
> > file.
> >  FATAL,53300,"too many connections for role ""user_app"""
>
> > db=\du user_app
> >                            List of roles
> >   Role name   |          Attributes           |     Member of
> > --------------+-------------------------------+--------------------
> >  user_app | No inheritance               +| {application_role}
> >               | 100 connections              +|
> >               | Password valid until infinity |
>
> Hm, what's the overall max_connections limit?  (I'm wondering
> in particular if it's more or less than 100.)
>
>                         regards, tom lane
>

Reply via email to