Re: Optional postgres database not so optional in 8.1

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: John Hansen <john(at)geeknet(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optional postgres database not so optional in 8.1
Date: 2005-11-17 14:17:15
Message-ID: c2d9e70e0511170617k1e670050q363de112f8994457@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/17/05, Martijn van Oosterhout <kleptog(at)svana(dot)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(at)svana(dot)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 ;)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-17 14:26:14 Re: Numeric 508 datatype
Previous Message Andrew Dunstan 2005-11-17 14:11:18 Re: Optional postgres database not so optional in 8.1