Skip site navigation (1) Skip section navigation (2)

Re: problem logging on with new everyday user

From: Gary Chambers <gwchamb(at)gwcmail(dot)com>
To: John <mrbruno(at)yahoo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: problem logging on with new everyday user
Date: 2012-09-28 14:12:29
Message-ID: alpine.DEB.2.00.1209281009540.10733@booby.gogca.com (view raw or flat)
Thread:
Lists: pgsql-novice
John,

> postgres=# \q
> johnp(at)sussancws0114:~/downloads$ /opt/PostgreSQL/8.4/bin/psql   -U bruno
> Password for user bruno: 
> psql: FATAL:  database "bruno" does not exist
> johnp(at)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


In response to

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2012-09-28 14:16:18
Subject: Re: problem logging on with new everyday user
Previous:From: JohnDate: 2012-09-28 14:07:29
Subject: problem logging on with new everyday user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group