-----Original Message-----
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]
Sent: Fri 6/17/2005 11:00 AM
To: Andreas Pflug
Cc: Magnus Hagander; Dave Page; Josh Berkus; pgsql-hackers@postgresql.org; Tom
Lane
Subject: Re: [HACKERS] Utility database (Was: RE: Autovacuum in the backend)
>> Probably, though the create db issue is a good reason not to use template1.
>
> Create db issue?
You can't create a db from template1 if other users are connected to it, which
means the most simple form of create database will fail.
>> So may I propose to have a pg_system database created by initdb, as a
>> copy from template1 in 8.1?
>
> But then dbas will block off access to that db, or drop it and we're
> back to square one...
That's their choice though, and it would then be up to them to provide an
alternative for their users (there's nothing to stop them doing the same with
template1 iirc). At least we would have a standard, non-template database for
utilities to connect to, whose purpose could be documented.
Regards Dave
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly