Wells Oliver schrieb am 19.04.2023 um 21:41:
I usually prefer pg_cancel_backend because it seems.. nicer, but lately I've had a troublesome user who leaves transactions open and I've scripted up a call to pg_terminate_backend after 60 minutes in an idle transaction. It works well.
Why don't you use the idle_in_transaction_session_timeout to do this automatically?
