How to change PostgreSQL Studio's inactivity timeout?

Question

I want to increase PostgreSQL's Studio login/session time out time. When I leave PostgreSQL Studio to idle just for some time, I get the following message:

You have been logged out due to inactivity. Please relogin or exit.

I am using PostgreSQL from BigSQL 5.0.3 package bundle. Actually, I am researching about compability of MS SQL Server and PostgreSQL queries.

As I am using Postgres now for learning purpose rather than security, I feel it annoying to login frequently.

How can I increase the login/session timeout inside PostgreSQL Studio?

Answer 1

Postgres itself doesn't have an idle connection timeout. This is coming from something else.

Answer 2

Unfortunately, the timeout value is hard-coded to 30 minutes in PostgreSQL Studio. You should only see that if you are not using Studio at all for 30 minutes. Its a pretty simple matter to move that property to the config file so it can be changed. We just need to write a patch.

The timeout is to prevent Studio from holding open idle connections to PostgreSQL. PostgreSQL Studio uses connection pooling to manage connections back to the database so if the browser connection goes away without logging out, we need a way to remove those connections.