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

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
>