problem logging on with new everyday user

From: John <mrbruno(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: problem logging on with new everyday user
Date: 2012-09-28 14:07:29
Message-ID: 1348841249.56389.YahooMailNeo@web162306.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am a newbie and just installed PostgreSQL 8.4 on Ubuntu.  I can get in with my postgres user but when I create an "everyday" user, I can't login with it:

johnp(at)sussancws0114:~/downloads$ /opt/PostgreSQL/8.4/bin/psql   -U postgres
Password for user postgres: 
psql (8.4.14)
Type "help" for help.

Cannot read termcap database;
using dumb terminal settings.
postgres=# drop user johnp;
DROP ROLE
postgres=# create user bruno password 'hello';
CREATE ROLE
postgres=# \du
            List of roles
 Role name | Attributes  | Member of 
-----------+-------------+-----------
 bruno     |             | {}
 postgres  | Superuser   | {}
           : Create role   
           : Create DB     

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Gary Chambers 2012-09-28 14:12:29 Re: problem logging on with new everyday user
Previous Message Johan Nel 2012-09-28 12:56:14 Re: Small annoyance with COPY FROM