Re: Problem with 'postgres' db with 8.0 on a MacBook - Mailing list pgsql-general

From Jonathon McKitrick
Subject Re: Problem with 'postgres' db with 8.0 on a MacBook
Date
Msg-id 20060607144457.GA57498@dogma.freebsd-uk.eu.org
Whole thread Raw
In response to Re: Problem with 'postgres' db with 8.0 on a MacBook  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Password for postgresql superuser?
Next
From: dananrg@yahoo.com
Date:
Subject: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model