Hi Jonathon,
does the following command succeed?
# psql template1 -c "CREATE DATABASE test;"
The database 'postgres' is a system table which has been added in 8.2
(or 8.1 already, dunno). It should exist if you used the correct initdb
and postmaster.
What does psql -l say?
And did you recheck permissions in pg_hba.conf?
BTW: nice laptop, isn't it? Linux still needs some work to run it,
tough. But I'm getting there ;-)
Regards
Markus
Jonathon McKitrick wrote:
Hi all,
this is my first time posting here because I've been running pgsql without
problem on a couple of Linux boxes for a while now.
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.
I installed after a manual build, chown'ed /usr/local/pgsql to postgres, added
a 'data' directory, and called initdb on it. But all calls to createdb or
createuser gave the message above.
Can anyone help?
Jonathon McKitrick
--
My other computer is your Windows box.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
