Postgres Pro
Downloads
Home   >   mailing lists

Auto close idle connections for specific user (not by pg_cancelcommand) - Mailing list pgsql-general

From Emi
Subject Auto close idle connections for specific user (not by pg_cancelcommand)
Date
Msg-id 77b0f43d-2397-d204-e569-b41f0f79361c@encs.concordia.ca
Whole thread Raw
Responses Re: Auto close idle connections for specific user (not by pg_cancel command)  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Connection issue
Next
From: Pavel Stehule
Date:
Subject: Re: Auto close idle connections for specific user (not by pg_cancel command)