From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
---|---|
To: | Jonathon McKitrick <jcm(at)FreeBSD-uk(dot)eu(dot)org> |
Subject: | Re: Problem with 'postgres' db with 8.0 on a MacBook |
Date: | 2006-06-07 13:29:19 |
Message-ID: | 4486D4AF.6080603@bluegap.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Leif B. Kristensen | 2006-06-07 13:31:07 | Re: [pgsql-advocacy] Me And My Database |
Previous Message | John Sidney-Woollett | 2006-06-07 13:21:40 | Re: Best open source tool for database design / ERDs? |