| From: | jgdon <REMOVEjgdon(at)ureach(dot)comREMOVE> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | psql ... does not like my user ... help please ;-) |
| Date: | 2002-07-25 12:12:48 |
| Message-ID: | 3D3FEB40.9020709@ureach.comREMOVE |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello I am playing with a fresh install of mandrake 8.2 and have decided
to use the postgresql db as my database for a simple phonebook application.
I am following the steps from a tutorial but can't seem to be able to
access my data base as the user i created ... I keep getting the msg:
psql: FATAL 1: IDENT authentication failed for user "jim"
I am going to keep reading ... but i will hopefully get an answer to
this post quicker [;-)]
Thanks for any help in advance,
Jim
ps my actual attempt is listed below ...
bash-2.05$ createuser jim -P
Enter password for user "jim":
Enter it again:
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
bash-2.05$ createdb gombaPhoneBookDB
CREATE DATABASE
bash-2.05$ psql phoneBookDB -U jim
psql: FATAL 1: IDENT authentication failed for user "jim"
bash-2.05$ psql phoneBookDB -u
psql: Warning: The -u option is deprecated. Use -U.
User name: jim
Password:
psql: FATAL 1: IDENT authentication failed for user "jim"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | terry | 2002-07-25 12:16:05 | pg_clog error |
| Previous Message | Jerome Chochon | 2002-07-25 11:48:58 | Add value in an Array |