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

Hi,
Maybe pgterminator could help you
https://github.com/trustly/pgterminator
Regards
Thomas

Le mar. 5 févr. 2019 à 18:52, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> a
écrit :

> Hi
>
>
> út 5. 2. 2019 v 18:47 odesílatel Emi <emilu(at)encs(dot)concordia(dot)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.
>>
>