Re: Keep Alive PGAdmin 1.8

On Tue, Apr 15, 2008 at 7:39 AM, Fil Matthews <fil(at)internetmediapro(dot)com> wrote:
> Sirs
>
> Thank You firstly for your fine front-end administration tool to
> Postgres.. As an ex ORACLE D.B.A. I appreciate what you have done.
>
> There is one point that I have not had the time or patience to find ..
>
> Perhaps my postgres servers are configured incorrectly but they have
> a wonderful habit ( of which I highly approve) of chucking out
> "idle" connections.
>
> Unfortunately my PGAdmin 1.8 connection is also seen as an "idle"
> connection after some period of non use ..

PostgreSQL doesn't do this - it tends to be poorly configured routers
or firewalls that are disconnecting the idle connections. The usual
advice for people that run into this problem is to connect via an ssh
tunnel and enable keepalives there.

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