Re: Optional postgres database not so optional in 8.1 - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Optional postgres database not so optional in 8.1
Date
Msg-id c2d9e70e0511170617k1e670050q363de112f8994457@mail.gmail.com
Whole thread Raw
In response to Re: Optional postgres database not so optional in 8.1  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
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 ;)


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Optional postgres database not so optional in 8.1
Next
From: Tom Lane
Date:
Subject: Re: tablespaces and non-empty directories