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

You are right. So it is not suitable for your case. Sorry Le mar. 5 févr. 2019 à 19:27, Ravi Krishna a écrit : > > > > > 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_tran

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

Or you could use Parameter idle_in_transaction_session_timeout 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/s

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

Hi, Maybe pgterminator could help you https://github.com/trustly/pgterminator Regards Thomas Le mar. 5 févr. 2019 à 18:52, Pavel Stehule a écrit : > Hi > > > út 5. 2. 2019 v 18:47 odesílatel Emi napsal: > >> Hello, >> >> In psql, may I know is there a way/config that idle connections could be >

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

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