The following bug has been logged online:

Bug reference: 1013
Logged by: Keith Hankin
Email address: keith105 (AT) yahoo (DOT) com
PostgreSQL version: 7.4
Operating system: Fedora Linux
Description: Authentication doesn't work
Details:

When I start up psql, if I am not not logged in as the owner of the database, I get the following error message, even if I type the correct password:

psql: FATAL: IDENT authentication failed for user "keith"

However, when I start up psql logged in as the owner of the database, I get a proper login regardless of whether I type the proper password or not.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
This is not a bug: it's the way it's supposed to work.

If you want to use passwords for authentication, you need to select a
password-based method in pg_hba.conf. Not IDENT.

Read the administrator's guide for more detail:
http://www.postgresql.org/docs/7.4/s...ntication.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly