From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: problem logging on with new everyday user |
Date: | 2012-09-28 14:16:18 |
Message-ID: | 20120928141618.GA7130@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
John <mrbruno(at)yahoo(dot)com> wrote:
> 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?
Read the error-message, you have an user 'bruno', but no database
'bruno'. This should work: psql -U bruno postgres (the last parameter is
the database to connect) or create a own database with 'create database
bruno'.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | SYDNEY TRAN | 2012-09-29 14:38:25 | Error 1920 |
Previous Message | Gary Chambers | 2012-09-28 14:12:29 | Re: problem logging on with new everyday user |