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.

Reply via email to