by default psql conects to a database by the same name as the user.
So you have two problems here.
There's no user or database named joe (assuming that's your username on
your system)
On a fresh install there's only one user, postgres, and only one
database to login, template1.
psql -U postgres template1
This should.
Once connected, create an user for you (and any other you might need).
You might want ot give it permissions to create DB's and users.
dado.
On a brand new installation
Joe Koenig wrote:
>This is the stupidest thing ever and I'm sure I'm missing something
>simple, but here goes:
>
>I installed postgres and started it up as the post-installation-notes
>file says to do. It starts up just fine, but I cannot log into the
>interactive monitor, nor can I create any databases, even as root. I
>checked the pg_hba.conf file and it is set to let all local users log
>in. Whenver I type:
>
>psql
>
>to try and log in, I get FATAL 1: Database "username" does not exist in
>the system catalog. I've used pgsql before, but never installed it, so I
>assume I missed something stupid, but looking back through the docs I'm
>still missing it. Can anyone help me? Thanks,
>
>Joe
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.