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...