Re: dropping connection

On Tue, Oct 13, 2009 at 6:59 PM, John <jfabiani(at)yolo(dot)com> wrote:
> Hi,
> I have a fellow assocate that uses pgAdmin3 remotely (he is in GA the DB is in
> CA).  He insists that a "time out" is somewhere in pgAdmin.  He loses
> connection often.  It has happen while are talking on Skype, or not talking
> on Skype.  It's also has happened while I was remotely connected.  The point
> being that other programs using the internet do not appear to disconnect.  I
> too have experienced a disconnect.  However, I have always blamed the poor
> internect connection I had at the time (like at a hotel).
>
> Is there such a setting (time out) that controls pgAdmin3 connections?  I
> don't experience any disconnects but I'm on the lan and he's using the wlan.

No, there is no such code in pgAdmin. It's possibly a NAT router or
WAP dropping the connection due to inactivity (which you're far less
likely to see with an app like Skype).

You could try playing with the tcp_keepalives_idle,
tcp_keepalives_interval and tcp_keepalives_count GUCs on your
colleagues login role though. That way, you can have it use keepalives
on any of his sessions.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com