Hi, Maybe pgterminator could help you https://github.com/trustly/pgterminator Regards Thomas
Le mar. 5 févr. 2019 à 18:52, Pavel Stehule <pavel.steh...@gmail.com> a écrit : > Hi > > > út 5. 2. 2019 v 18:47 odesílatel Emi <em...@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. >> >
