Re: Problem with 'postgres' db with 8.0 on a MacBook

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathon McKitrick <jcm(at)FreeBSD-uk(dot)eu(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with 'postgres' db with 8.0 on a MacBook
Date: 2006-06-07 14:31:22
Message-ID: 29765.1149690682@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathon McKitrick <jcm(at)FreeBSD-uk(dot)eu(dot)org> writes:
> I'm migrating to a new MacBook, and while I finally got it to compile, initdb,
> and start a postmaster, any time I try createdb or createuser, I get a message
> that the database 'postgres' cannot be found.

It sounds to me like you're trying to use PG 8.1 client tools with an
8.0 (or older) postmaster. 8.1 tools expect there to be a 'postgres'
database created by default, but that is not the convention in older
releases. Better check exactly what's laying around already on that
machine. Apple does ship some version of Postgres in OS X IIRC...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-07 14:32:57 Re: Action Table of postgresql
Previous Message Tom Lane 2006-06-07 14:27:50 Re: autovacuum, xid wraparound, pg_database column values