Re: PMChildFlags array

bhargav kamineni <bhargavpostgres(at)gmail(dot)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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> bhargav kamineni <bhargavpostgres(at)gmail(dot)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
>