Re: Auto close idle connections for specific user (not by pg_cancel command)

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Auto close idle connections for specific user (not by pg_cancel command)
Date: 2019-02-05 17:51:59
Message-ID: CAFj8pRCSBpyMn9rrEepMi5OCfFYqgAFxhWMnZeQVcz3siATYpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Poty 2019-02-05 17:59:31 Re: Auto close idle connections for specific user (not by pg_cancel command)
Previous Message Emi 2019-02-05 17:47:10 Auto close idle connections for specific user (not by pg_cancel command)