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

On Wed, Jun 07, 2006 at 10:31:22AM -0400, Tom Lane wrote:
: Jonathon McKitrick <jcm@FreeBSD-uk.eu.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...

That could very well be.  I've been installing a couple of versions over one
another, since I couldn't get them to work for various reasons and because gnu
software doesn't have a 'make deinstall'.

How can I remove all the cruft from a previous version?

And where is pg_hba.conf?



Jonathon McKitrick
--
My other computer is your Windows box.