Skip site navigation (1) Skip section navigation (2)

Re: Keep-alive?

From: "Mark Rappoport" <mark(at)nsa(dot)co(dot)il>
To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Keep-alive?
Date: 2003-10-08 11:18:56
Message-ID: 009101c38d8d$f6871960$0b00000a@famine (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Dave, thanks for the swift reply.

No, we're working on a server in a farm; the local office connection is
a regular ADSL one, going through a Cisco PIX. The farm is about 4 hops
away.
I suppose that the PIX is somehow affecting the connection... There's
probably a multitude of factors affecting this, and I doubt that it's
the fault of the database backend or pgAdmin... 

Regardless, I think that PGAdmin should offer some kind of option to
automagically reconnect if it sees that the connection is no longer
alive. 

Perhaps there are other pgAdmin users experiencing such disconnections,
who would benefit from this?

Anyway, thanks. I'll look into the TCP streams heading in and out of
here and see what's causing this.

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: Wednesday, October 08, 2003 1:07 PM
> To: mark(at)nsa(dot)co(dot)il; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Keep-alive?
> 
> 
> 
> 
> > -----Original Message-----
> > From: Mark Rappoport [mailto:mark(at)nsa(dot)co(dot)il]
> > Sent: 08 October 2003 12:01
> > To: pgadmin-support(at)postgresql(dot)org
> > Subject: [pgadmin-support] Keep-alive?
> > 
> > 
> > Perhaps I've missed something - if so, I apologize for
> > wasting the list's time.
> > 
> > Is there some support for keeping PostgreSQL connections
> > alive? That is, I often start PGAdmin and leave it idle in 
> > the background; when I return to it, and hit an item in the 
> > tree, I get about 10-15 message boxes telling me that the 
> > server is offline.
> > 
> > Are there any plans to change this functionality?
> 
> Hi Mark,
> 
> Neither pgAdmin nor PostgreSQL implement any kind of 
> connection timeout. Communication is via a TCP connection 
> which is maintained by the TCP stack on the client and the 
> server. If you are getting disconnected from your server, 
> then I would guess that there is something else on your 
> network causing the problem. Ar you working across any ISDN 
> links or similar?
> 
> Regards, Dave.
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index 
> scan if your
>       joining column's datatypes do not match
> 


In response to

Responses

pgadmin-support by date

Next:From: Michiel_LangeDate: 2003-10-08 11:27:51
Subject: Re: Keep-alive?
Previous:From: Dave PageDate: 2003-10-08 11:06:56
Subject: Re: Keep-alive?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group