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

One thing I have noticed with my install (may be something carrying over
from an old version or howto I followed way back) is that the main user is
pgsql but the default db is postgres I find I need to use
#psql -U pgsql -d postgres

By default psql tries to connect to the database of the same name as the
pgsql user you log in as (unless specified with the -U option it will use
the current system username)

You may want to use '-d test' to match the test db you created with the
previous instruction or another that shows in the psql -l list.

On 8/6/2006 3:18, "Markus Schiltknecht" <markus(at)bluegap(dot)ch> wrote:

> Hi Jonathon,
>
> Jonathon McKitrick wrote:
>> : # psql template1 -c "CREATE DATABASE test;"
>>
>> CREATE DATABASE
>>
>> is the result.
>
> Looks good. Can you connect to that database then?
>
>> : What does psql -l say?
>>
>> FATAL: database 'postgres' does not exist
>
> As Tom said: check if you are really calling you self-compiled binaries:
>
> # which pgsql
>
> Markus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>