I would like to set idle_in_transaction_session_timeout for a Heroku Postgres database

Question

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?

Answer 1

You can change it for your own user:

alter user current_user set idle_in_transaction_session_timeout = '5min';