Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Thu, 17 Nov 2005 09:17:15 -0500
  • Message-id: <c2d9e70e0511170617k1e670050q363de112f8994457(at)mail(dot)gmail(dot)com>

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 ;)



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group