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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Auto close idle connections for specific user (not by pg_cancel command)
Дата
Msg-id CAFj8pRCSBpyMn9rrEepMi5OCfFYqgAFxhWMnZeQVcz3siATYpg@mail.gmail.com
обсуждение исходный текст
Ответ на Auto close idle connections for specific user (not by pg_cancelcommand)  (Emi <emilu@encs.concordia.ca>)
Ответы Re: Auto close idle connections for specific user (not by pg_cancel command)  (Thomas Poty <thomas.poty@gmail.com>)
Список pgsql-general
Hi


út 5. 2. 2019 v 18:47 odesílatel Emi <emilu@encs.concordia.ca> napsal:
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.

What I know, there is not any timeout for this purpose.

Maybe pgbouncer can do this https://pgbouncer.github.io/config.html

client_idle_timeout

Regards

Pavel

Thanks a lot.

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

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