Postgres Pro
Downloads
Home   >   mailing lists

Re: Auto close idle connections for specific user (not by pg_cancel command) - Mailing list pgsql-general

From Thomas Poty
Subject Re: Auto close idle connections for specific user (not by pg_cancel command)
Date
Msg-id CAN_ctnh-5HRuO8dYCQFJjJOX1sZvT2xJXctnL-gWL9tcik2=rw@mail.gmail.com
Whole thread Raw
In response to Auto close idle connections for specific user (not by pg_cancelcommand)  (Emi <emilu@encs.concordia.ca>)
List pgsql-general
Tree view
You are right. So it is not suitable for your case. Sorry 

Le mar. 5 févr. 2019 à 19:27, Ravi Krishna <srkrishna100@aol.com> 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 ?

pgsql-general by date:

Previous
From: Thomas Poty
Date:
Subject: Re: Auto close idle connections for specific user (not by pg_cancel command)
Next
From: Ricardo Martin Gomez
Date:
Subject: RE: Connection issue