Re: problem logging on with new everyday user - Mailing list pgsql-novice

John,

> postgres=# \q
> johnp@sussancws0114:~/downloads$ /opt/PostgreSQL/8.4/bin/psql   -U bruno
> Password for user bruno:
> psql: FATAL:  database "bruno" does not exist
> johnp@sussancws0114:~/downloads$

> What am I doing wrong?

Without PGDATABASE set, psql assumes that a database with the same name as
the user connecting exists.  Just add the database name to the psql command
and you should be all set.

--
Gary Chambers