0

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?

Julius
  • 1,451
  • 1
  • 15
  • 19

1 Answers1

1

You can change it for your own user:

alter user current_user set idle_in_transaction_session_timeout = '5min';
  • I am not sure this is working. If I run ```show idle_in_transaction_session_timeout;``` it still shows me 0 and all the sessions that are idle in transaction haven't been terminated after 5 minutes. – Julius Mar 18 '22 at 15:07
  • 1
    I think you need to disconnect and re-connect. Existing sessions won't be affected as far as I know –  Mar 18 '22 at 15:23