How to keep connection alive in pgAdmin

Question

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?

Sounds like you're connecting to a machine through a NAT router, a proxy, or some other kind of connection tracking system. If so, Andrew is right and you need to set up TCP keepalives. — Craig Ringer, Jul 22 '13 at 03:08

score 7 · Accepted Answer · answered Jul 21 '13 at 02:03

7

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

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

answered Jul 21 '13 at 02:03

Andrew

515
1
4
16

2

Do you know if this can bring performance issues in a production environment? – Marcio Mazzucato Feb 13 '15 at 13:35

score 2 · Answer 2 · edited Mar 20 '17 at 10:17

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?

How to keep connection alive in pgAdmin

2 Answers2

Linked