Re: [PATCHES] default database creation with initdb - Mailing list pgsql-hackers

From Dave Page
Subject Re: [PATCHES] default database creation with initdb
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E490E5CC@ratbert.vale-housing.co.uk
Whole thread Raw
Responses Re: [PATCHES] default database creation with initdb
List pgsql-hackers

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

Regards, Dave


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [PATCHES] default database creation with initdb
Next
From: "Dave Page"
Date:
Subject: Re: [PATCHES] default database creation with initdb