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@RH-Dev djoo]# /etc/init.d/postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Karsten Hilbert
Sent: Tuesday, May 20, 2008 9:27 AM
To: pgsql-general@postgresql.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@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general