On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
>>> The problem is users will connect using DBeaver and their sessions
>>> will sit idle.
>> Idle is not a problem, "idle in transaction" is.
> From my perspective "idle in transaction" isn't necessarily a problem (although I don't like seeing sessions sitting like that for a long time).
Well, it is, since you /are/ sitting in an open transaction.
This fixes it: idle_in_transaction_session_timeout
https://www.postgresql.org/docs/9.6/runtime-config-client.html
--
Born in Arizona, moved to Babylonia.