Re: [PATCHES] default database creation with initdb

On Tuesday 21 June 2005 04:01, Dave Page wrote:
> > -----Original Message-----
> > From: Christopher Kings-Lynne [mailto:chriskl(at)familyhealth(dot)com(dot)au]
> > Sent: 21 June 2005 08:57
> > To: Dave Page
> > Cc: Robert Treat; Tom Lane; Andrew Dunstan; Andreas Pflug;
> > Magnus Hagander; pgsql-hackers(at)postgresql(dot)org
> > Subject: Re: [HACKERS] [PATCHES] default database creation with initdb
> >
> > > Yes - that's intentional so that pgAdmin/phpPgAdmin et al. can
> > > reasonably expect it to be there.
> >
> > Problem is, how the hell do I know it's there before I connect?
>
> Well obviously you don't (any more than you know that template1 is
> accessible until you try), but in time it will be on more and more
> systems as people upgrade by when it will make a reasonable default for
> clients.
>
> Alternatively, try to connect to it first, and then fall back to
> template1 (much as libpq negotiates protocol versions with the server).
>

You know, since we don't maintain static connections (http is our friend)
connecting to template1 really isn't a problem for phppgadmin users. At
least I can't remember anyone ever having complained about it.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL