| From: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Posgresql-13 Bug (idle_in_transaction_session_timeout) |
| Date: | 2022-05-11 11:45:35 |
| Message-ID: | CAD21AoCfiMz-QCrWVvgrjtOErZ0WVw9TkXBwMqmOE=2C5MfNDA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
On Wed, May 11, 2022 at 6:19 PM Ram Pratap Maurya
<ram(dot)maurya(at)lavainternational(dot)in> wrote:
>
> Hi Team,
>
>
>
> As per in screen shot in each process occupies a scission that why our server unable to new request in postgres.
>
> Please susggest what is solution of idel query.
>
You need to either terminate unused sessions or increase
max_connections[1] to accept new connections.
This list is for bug reports and it's not a bug. Please ask questions
on pgsql-general mailing list.
[1] https://www.postgresql.org/docs/13/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
--
Masahiko Sawada
EDB: https://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-05-11 23:11:25 | Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery |
| Previous Message | Ram Pratap Maurya | 2022-05-11 09:19:05 | RE: Posgresql-13 Bug (idle_in_transaction_session_timeout) |