How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I have to force close it and open it again.

This is very annoying. Is there a way to keep alive the connection in pgAdmin?

Solution 1:

That's configured from the server - the the tcp_keepalives_* settings

at http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html

Solution 2:

Actually I think there are two issues here. 1. The keep alive of the connection on the db server 2. The problem of your service provider closing idle tcp connections. In my case Pgadmin needs to ping the server so that the tcp connection remains active. I discovered this after changing internet providers.

There is a solution to this posted here Any way to keep connection alive in pgAdmin without setting it on the server?