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

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема Re: Auto close idle connections for specific user (not by pg_cancel command)
Дата
Msg-id CAN_ctnh-5HRuO8dYCQFJjJOX1sZvT2xJXctnL-gWL9tcik2=rw@mail.gmail.com
обсуждение исходный текст
Ответ на Auto close idle connections for specific user (not by pg_cancelcommand)  (Emi <emilu@encs.concordia.ca>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Thomas Poty
Дата:
Сообщение: Re: Auto close idle connections for specific user (not by pg_cancel command)
Следующее
От: Ricardo Martin Gomez
Дата:
Сообщение: RE: Connection issue