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@xxxxxxxxxx> 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 >
