Re: Keep Alive PGAdmin 1.8

On Tue, 2008-04-15 at 08:32 +0100, Dave Page wrote:
> On Tue, Apr 15, 2008 at 7:39 AM, Fil Matthews <fil@internetmediapro.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

Yeh, it does:
http://developer.postgresql.org/pgdocs/postgres/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

They're user settable, so pgadmin could offer that as an option. But you
can augment the pgadmin userid with a SET command to implement this
yourself as a user, see ALTER USER.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com