Re: Utility database (Was: RE: Autovacuum in the backend)

-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl(at)familyhealth(dot)com(dot)au]
Sent: Fri 6/17/2005 11:00 AM
To: Andreas Pflug
Cc: Magnus Hagander; Dave Page; Josh Berkus; pgsql-hackers(at)postgresql(dot)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