Hi,
On Wed, May 11, 2022 at 4:52 PM Ram Pratap Maurya
<ram.maurya@lavainternational.in> wrote:
>
> Hi Team,
>
>
>
> I have enable parameter “idle_in_transaction_session_timeout” in Postgresql-13 conf file.
>
> But still Ideal connection exist in system more the defined ideal time.
>
>
>
> I have defined ideal time 28800000 milliseconds. second (8Hrs) .
>
>
>
> Can you please check and suggest , screen shot attached for reference.
idle_in_transaction_session_timeout is a timeout for sessions that
have been idle within an open transaction. But looking at the
screenshot you shared, the processes are in an idle state, not an
idle-in-transaction state. idle_session_timeout sets a timeout for
sessions that are in an idle state but it's available in PostgreSQL 14
or later.
Regards,
--
Masahiko Sawada
EDB: https://www.enterprisedb.com/