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?
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 |