Re: psql: FATAL: Ident authentication failed for user"postgres"

On Tue, May 20, 2008 at 08:50:16AM -0700, Dan Joo wrote:

> The only non-commented lines are:
> 
> [root@RH-Dev data]# cat pg_hba.conf | grep -v '^#'
> 
> local   all         all                               trust
> host    all         all         127.0.0.1/32          trust
> host    all         all         ::1/128               trust

Well, neither of which allows IDENT based authentication.

This doesn't explain, however, why it's attempting IDENT in
the first place. It really *should* just work due to the
first line.

Is this the pg_hba.conf that's actually being used ? Perhaps
there's another one lying in another cluster's directory ?

What happens if you rename it so PG cannot find it anymore
- does PG complain about the missing file ?

> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Karsten Hilbert

Interesting. Are my mails being screened ?

> > confused why I can't access.  Is there another file that I need to
> alter
> > besides the pg_hba.conf file?  
> 
> That depends on the content of your pg_hba.conf file.

Assuming the above really IS the file in use the answer is
No.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346