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

Thanks a lot.

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.

Hi,
Maybe pgterminator could help you
https://github.com/trustly/pgterminator
Regards
Thomas

Le mar. 5 févr. 2019 à 18:52, Pavel Stehule <pavel.stehule@gmail.com> a
écrit :

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.

https://www.cybertec-postgresql.com/en/idle_in_transaction_session_timeout-terminating-idle-transactions-in-postgresql/

And use alter role in database set idle_in_transaction_session_timeout

to...

https://www.postgresql.org/docs/10/sql-alterrole.html

But this works only for those sessions which has started a transaction and
not committed within the session_timeout period, right ?