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.
>