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 >