Auto close idle connections for specific user (not by pg_cancelcommand)

Поиск
Список
Период
Сортировка
От Emi
Тема Auto close idle connections for specific user (not by pg_cancelcommand)
Дата
Msg-id 77b0f43d-2397-d204-e569-b41f0f79361c@encs.concordia.ca
обсуждение исходный текст
Ответы Re: Auto close idle connections for specific user (not by pg_cancel command)  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hello,

In psql, may I know is there a way/config that idle connections could be auto closed (but not by pg_cancel_backend command) for specific user(s) please?

For example, 
select  usename, waiting, query_start  from pg_stat_activity 
where usename like 'connUser1' and
           current_query='<IDLE>';

All connections from connUser1, if idle more than 1 day, psql auto close them.

Thanks a lot.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Connection issue
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Auto close idle connections for specific user (not by pg_cancel command)