On 11/17/05, Martijn van Oosterhout <kleptog@svana.org> wrote:
> On Fri, Nov 18, 2005 at 12:01:31AM +1100, John Hansen wrote:
> > On a fresh installation of postgrsql 8.1 if you drop the
> > 'postgres' database,
> > psql, createdb, etc. no longer works.
> >
> > psql -l; ignores -dtemplate1, and createdb doesn't have such an option.
>
> What distribution? I've never seen this "postgres" database you speak
> of. It certainly not on any systems I've used. Do you have a PGDATABASE
> variable in your environment?
>
> Have a nice day,
> --
> Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> > tool for doing 5% of the work and then sitting around waiting for someone
> > else to do the other 95% so you can sue them.
>
>
That database exists beginning with 8.1... I don't think it's optional...
i remember a comments from Tom telling that this database will be used
to connect to for CREATE DATABASE porpouses:
http://archives.postgresql.org/pgsql-committers/2005-06/msg00302.php
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)