Hi Vikram,
Please use the mailing lists instead of personal email.
> -----Original Message-----
> From: Vikram Rangnekar [mailto:vicram@gmail.com]
> Sent: 22 October 2004 08:02
> To: Dave Page
> Subject: stay-alive-ping in pgadmin
>
> I've noticed a problem that seems to occur with people using
> personal firewalls which maintain per connection session
> information. When using an app like pgadmin if I leave it
> connected to the remote postgres server and dont really
> perform any activity using pgadmin for sometime the firewall
> session information expires and it stops passing pgadmin
> traffic through it even though the tcp connection is still in
> session so when I come back in say an hour and try to pgadmin
> which I had previously left connected it crashes since the
> connection is not technical closed but it cannot pass or
> recive any traffic to and from the remote postgres server.
>
> so i suggest incorporating some kind of a keep-alive-ping
> into pgadmin. All desktops apps which dont perform continuous
> network activity and lie behind personal firewalls need a
> mechanism like that.
> where pgadmin does some random network activity every few
> minutes or seconds a refresh of data from the server will do fine.
This problem is discussed in the faq at:
http://pgadmin.postgresql.org/pgadmin3/faq/#ConnDrop
> thanks, and thank again for the aswome application is really
> helped me a lot when I work with postgres.
You're welcome.
Regards, Dave