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?

user330315 · Accepted Answer · 2022-03-18 11:55:55Z

1

You can change it for your own user:

alter user current_user set idle_in_transaction_session_timeout = '5min';

answered Mar 18, 2022 at 11:55

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

Julius Over a year ago

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.

user330315 Over a year ago

I think you need to disconnect and re-connect. Existing sessions won't be affected as far as I know

Collectives™ on Stack Overflow

I would like to set idle_in_transaction_session_timeout for a Heroku Postgres database

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related