dropping connection

[jfabiani]

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.

Johnf

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Guillaume Lelarge-3]

Le mardi 13 octobre 2009 à 19:59:04, John a écrit :

> 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's no such thing. It may be related to your firewall or to
PostgreSQL.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Tue, Oct 13, 2009 at 6:59 PM, John <jfabiani@...> 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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

The connection to the database is dropped occasionally (as far as I can tell, independently of internet connectivity issues).  I have experienced this quite a lot. I do not think it is PgAdmin that drops the connection. Could be postgres itself is dropping the connection.

There have been a number of requests for PgAdmin to ty to reestablish the connection "behind the scenes" (at least once) before giving up and reporting a lost connection.

On Tue, Oct 13, 2009 at 1:11 PM, Guillaume Lelarge <guillaume@...> wrote:

Le mardi 13 octobre 2009 à 19:59:04, John a écrit :

> 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's no such thing. It may be related to your firewall or to
PostgreSQL.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support