Re: Keep-alive?

This may very well be a firewall/router thing...
Since the amount of sockets (which are needed for any TCP connection) is
limited, your gateway/firewall may very well delete a socket that has been
idle for a certain amount of time.
There is a ICMP message KeepAlive, which does nothing but send some kind of
ping which keeps the connection alive... You cannot send these messages
outside the application, there would be a new socket made for that, so it
would not help you very much. I think that adding an option to PgAdmin
"send keepalive packages every <##> seconds" would be a valuable
addition...

Michiel

|--------+------------------------------------>
| | "Mark Rappoport" |
| | <mark(at)nsa(dot)co(dot)il> |
| | Sent by: |
| | pgadmin-support-owner(at)post|
| | gresql.org |
| | |
| | |
| | 08-10-2003 13:18 |
| | Please respond to mark |
| | |
|--------+------------------------------------>
>-----------------------------------------------------------------------------------------------------------|
| |
| To: "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, <pgadmin-support(at)postgresql(dot)org> |
| cc: |
| Subject: Re: [pgadmin-support] Keep-alive? |
>-----------------------------------------------------------------------------------------------------------|

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
>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly