Search Postgresql Archives

Re: Auto close idle connections for specific user (not by pg_cancel command)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You are right. So it is not suitable for your case. Sorry 

Le mar. 5 févr. 2019 à 19:27, Ravi Krishna <srkrishna100@xxxxxxx> a écrit :
>
> https://www.cybertec-postgresql.com/en/idle_in_transaction_session_timeout-terminating-idle-transactions-in-postgresql/
>
> And use alter role in database set idle_in_transaction_session_timeout to...
>
> https://www.postgresql.org/docs/10/sql-alterrole.html

But this works only for those sessions which has started a transaction and not committed within the session_timeout period, right ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux