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@familyhealth.com.au]
> > Sent: 21 June 2005 08:57
> > To: Dave Page
> > Cc: Robert Treat; Tom Lane; Andrew Dunstan; Andreas Pflug;
> > Magnus Hagander; pgsql-hackers@postgresql.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