| From: | the inquirer <listquestions(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Authentication problems |
| Date: | 2004-08-20 15:33:23 |
| Message-ID: | 20040820153323.36936.qmail@web61207.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
I am a new postgres user who is having trouble
figuring out how user-based authentication is supposed
to work. I create a database, create a user and
attempt to use psql to connect to the new database
using the new user. However, the server always
responds with "psql: FATAL: IDENT authentication
failed for user "user". Are there additionaly
security of configuration tasks that need to be done?
Here are the commands I am executing as the user
postgres:
$ createdb database
CREATE DATABASE
$ createuser -P user
Enter password for new user:
Enter it again:
Shall the new user be allowed to create databases?
(y/n) n
Shall the new user be allowed to create more new
users? (y/n) n
CREATE USER
$ psql -W -d database -U user
Password:
psql: FATAL: IDENT authentication failed for user
"user"
I am running on Debian Sarge kernel versin 2.4.25-1.
All of my postgresql pkgs are 7.4.3-3.
Thanks,
listquestions.
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Sidney-Woollett | 2004-08-20 15:43:14 | Re: insert waiting |
| Previous Message | Tom Lane | 2004-08-20 15:29:16 | Re: Postgres "invalid page header" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SVGK, Raju (Raju) | 2004-08-20 15:56:34 | view triggers/procedures |
| Previous Message | Tom Lane | 2004-08-20 15:15:00 | Re: dup(0) failed after 3195 successes: Bad file descriptor |