Re: psql: FATAL: Ident authentication failed foruser"postgres"

Great suggestion!

I renamed it to "pg_hba.conf_tmp", and I can still log into PG. There
is another linux box in the network and changed the title of the
pg_hba.conf file as well, and still allows me to log in to PG.

Is there a command that I can use to find out which file PG is looking
into for the settings in pg_hba.conf? Could it be that the config file
is not even titled "pg_hba.conf"?

Just so that you know, I restarted postgres after changing the file
names in both machines.

[root(at)RH-Dev djoo]# /etc/init.d/postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Karsten Hilbert
Sent: Tuesday, May 20, 2008 9:27 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed
foruser"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