Re: Posgresql-13 Bug (idle_in_transaction_session_timeout) - Mailing list pgsql-bugs

From Masahiko Sawada
Subject Re: Posgresql-13 Bug (idle_in_transaction_session_timeout)
Date
Msg-id CAD21AoCfiMz-QCrWVvgrjtOErZ0WVw9TkXBwMqmOE=2C5MfNDA@mail.gmail.com
Whole thread Raw
In response to RE: Posgresql-13 Bug (idle_in_transaction_session_timeout)  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-bugs
Hi,

On Wed, May 11, 2022 at 6:19 PM Ram Pratap Maurya
<ram.maurya@lavainternational.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/



pgsql-bugs by date:

Previous
From: Ram Pratap Maurya
Date:
Subject: RE: Posgresql-13 Bug (idle_in_transaction_session_timeout)
Next
From: Tom Lane
Date:
Subject: Re: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery