Windows – How to keep connection alive in pgAdmin

pgadminpostgresqlwindows

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?

Best Answer

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

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