Lee Hachadoorian wrote:
I use the SQL editor in pgAdmin for all of my database work. The problem I'm having is that after a period of inactivity, pgAdmin loses the connection to the server. I'm trying to figure out how to avoid this happening. Not being a network administrator, I'm wondering if this is related to the tcp_keepalives settings described at http://www.postgresql.org/docs/8.4/static/runtime-config-connection.html. Can someone confirm that I'm looking at the right settings, or is there something else that might cause clients to lose the connection? The connection seems to be being lost after ~ 15-20 minutes of inactivity.
are you running pgadmin and postgres server on the same computer, or on different computers?
if different computers, is there any sort of connection tracking in between, such as a NAT router/gateway?
15-20 mins sounds a lot like the typical NAT idle connection timeout... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general