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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Karsten Hilbert Sent: Tuesday, May 20, 2008 9:27 AM To: pgsql-general@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
