On 2019-Oct-03, bhargav kamineni wrote:
> bhargav kamineni <bhargavpostgres@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 |
Was the machine overloaded at the time the problem occurred?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services