Postgres Pro
Downloads
Home   >   mailing lists

Re: Auto close idle connections for specific user (not by pg_cancel command) - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Auto close idle connections for specific user (not by pg_cancel command)
Date
Msg-id CAFj8pRCSBpyMn9rrEepMi5OCfFYqgAFxhWMnZeQVcz3siATYpg@mail.gmail.com
Whole thread Raw
In response to Auto close idle connections for specific user (not by pg_cancelcommand)  (Emi <emilu@encs.concordia.ca>)
Responses Re: Auto close idle connections for specific user (not by pg_cancel command)  (Thomas Poty <thomas.poty@gmail.com>)
List pgsql-general
Tree view
Hi


út 5. 2. 2019 v 18:47 odesílatel Emi <emilu@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.

pgsql-general by date:

Previous
From: Emi
Date:
Subject: Auto close idle connections for specific user (not by pg_cancelcommand)
Next
From: Thomas Poty
Date:
Subject: Re: Auto close idle connections for specific user (not by pg_cancel command)