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(at)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(at)postgresql(dot)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