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
$ createdb database
$ createuser -P user
Enter password for new user:
Enter it again:
Shall the new user be allowed to create databases?
Shall the new user be allowed to create more new
users? (y/n) n
$ psql -W -d database -U user
psql: FATAL: IDENT authentication failed for user
I am running on Debian Sarge kernel versin 2.4.25-1.
All of my postgresql pkgs are 7.4.3-3.
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
pgsql-novice by date
|Next:||From: SVGK, Raju (Raju)||Date: 2004-08-20 15:56:34|
|Subject: view triggers/procedures|
|Previous:||From: Tom Lane||Date: 2004-08-20 15:15:00|
|Subject: Re: dup(0) failed after 3195 successes: Bad file descriptor |
pgsql-general by date
|Next:||From: John Sidney-Woollett||Date: 2004-08-20 15:43:14|
|Subject: Re: insert waiting|
|Previous:||From: Tom Lane||Date: 2004-08-20 15:29:16|
|Subject: Re: Postgres "invalid page header" |