1

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.

enter image description here

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?

S-Man
  • 22,521
  • 7
  • 40
  • 63
Yashasvi Raj Pant
  • 1,274
  • 4
  • 13
  • 33
  • [Are you sure that's the actual error message](https://www.google.com/#q="Please+relogin+or+exit+postgres") – ta.speot.is Jul 26 '14 at 03:10
  • @ta.speot.is, Yes that's the actual error message.. – Yashasvi Raj Pant Jul 26 '14 at 03:13
  • 2
    "postgres" has no "web console". Whatever you're using, it's not just PostgreSQL, it's some other part of the bundle you're using. Is this PgPHPAdmin you're talking about? Something else? (I've never heard of BigSQL) – Craig Ringer Jul 26 '14 at 04:00
  • It's PostgreSQL studio..BigSQL is the package bundle that comes with Postgres, Hadoop, Zookeeper, Hive etc. – Yashasvi Raj Pant Jul 26 '14 at 04:12
  • @user3306594 Well, what's the "etc". What are you actually using? There should be an about page or help page somewhere that tells you what the web console component is. – Craig Ringer Jul 26 '14 at 07:12
  • Re-tagged with `postgresqlstudio` as this is clearly not a Postgres question –  Jul 26 '14 at 11:01
  • @user3306594 is talking about PostgreSQL Studio http://www.postgresqlstudio.org/ . See corrected message and picture. – Alex Bitek Oct 29 '14 at 14:10

2 Answers2

2

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

dodexahedron
  • 4,584
  • 1
  • 25
  • 37
0

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.

Jim
  • 761
  • 4
  • 4
  • I've tried changing the session-timeout inside conf/web.xml to a bigger value however this does not fix the problem, the same message is shown after a period of time. I think the timeout is **less** than 30 minutes. – Alex Bitek Oct 29 '14 at 14:13