On Wed, Jun 07, 2006 at 10:31:22AM -0400, Tom Lane wrote:
: Jonathon McKitrick <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
