Re: PMChildFlags array
От | bhargav kamineni |
---|---|
Тема | Re: PMChildFlags array |
Дата | |
Msg-id | CADCf-WMUZ71-nbWmk6fF3jP3S8wOy-Vp_0QPMxV2bnP8szFJ_g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PMChildFlags array (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: PMChildFlags array
|
Список | pgsql-general |
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 |
>Hm, what's the overall max_connections limit? (I'm wondering
in particular if it's more or less than 100.)
> 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
max_connections
-----------------
500
On Thu, 3 Oct 2019 at 22:52, Tom Lane <tgl@sss.pgh.pa.us> 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 |
Hm, what's the overall max_connections limit? (I'm wondering
in particular if it's more or less than 100.)
regards, tom lane
В списке pgsql-general по дате отправления: