Based on this solution I would like to change the idle_in_transaction_session_timeout in Heroku Postgres, however I do not have the rights as a superuser (see Heroku default permissions). Are there any alternatives to this?

CodePudding user response：

You can change it for your own user:

alter user current_user set idle_in_transaction_session_timeout = '5min';