I am currently seeing an issue where when Postgres shutsdown, the existing transactions are still lingering around and keep “hanging”. I did set idle_in_transaction_timeout = 60000 so it removes any idle transactions.

However, is there a setting where I can have it that if Postgres shuts down or errors out, those transactions gets terminated?
I did find something called exit_on_error but it seems to be for exiting postgres itself if any error occurs, which is probably not it? I can’t seem to find any other configuration to do what I want.

TLDR: I want to set in postgresql.conf (or elsewhere) so that if Postgres shutsdown, it automatically terminates all transactions.