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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Keep Alive PGAdmin 1.8



On Thu, Apr 17, 2008 at 8:26 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Tue, 2008-04-15 at 08:32 +0100, Dave Page wrote:
>  > PostgreSQL doesn't do this
>
>  Yeh, it does:
>  http://developer.postgresql.org/pgdocs/postgres/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

I meant it doesn't drop "idle" connections.

>  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.

Hmm, didn't realise we'd added that. Nice. It appears to have been
added for 8.1 though, so if you're running an older server than that
(pgAdmin supports back to 7.3), you should use the ssh tunnel trick.

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group