Thread: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
Dear Friends,
I have installed Linux Fedore and wanted to work with the default installed postgres 7.3.4 database.
I could able to create to create user, but while try to connect, I got the following error message
psql: FATAL 1: IDENT authentication failed for user
My pg_hba.conf file looks like below
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
host all all 192.168.2.0 255.255.255.0 trust
host all all 192.168.2.0 255.255.255.0 trust
I couldnt understand why. Please shed some light
Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
From
Martin Marques
Date:
El Vie 19 Mar 2004 09:39, Kumar escribió: > Dear Friends, > > I have installed Linux Fedore and wanted to work with the default installed > postgres 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the > following error message psql: FATAL 1: IDENT authentication failed for user > > My pg_hba.conf file looks like below > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all trust > host all all 192.168.2.0 255.255.255.0 trust > > I couldnt understand why. Please shed some light This is not the default configuration, so I suspect that you changed it. Try to reload PostgreSQL and try again. -- 10:04:02 up 10 days, 14:35, 4 users, load average: 0.27, 0.24, 0.27 ----------------------------------------------------------------- Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 19 Mar 2004, Kumar wrote: > I have installed Linux Fedore and wanted to work with the default installed postgres 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the following error message > psql: FATAL 1: IDENT authentication failed for user > > My pg_hba.conf file looks like below > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all trust > host all all 192.168.2.0 255.255.255.0 trust Are you sure that you've commented (or maybe deleted) the "ident" line? AFAIR, if there is a line about ident auth before the lines that you've pasted, PostgreSQL will take care of that line and will try ident auth. Also, a reload is required after a change in pg_hba.conf. Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.TDMSoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFAWwJPtl86P3SPfQ4RAnh4AKCPqY2Xu/ZBkuytA1puv2qtBN5AwQCglCuZ 7kouiIpk0hvxOOuAxhfPZnY= =ktdd -----END PGP SIGNATURE-----
Martin Marques <martin@bugs.unl.edu.ar> writes: > El Vie 19 Mar 2004 09:39, Kumar escribi�: >> My pg_hba.conf file looks like below >> >> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD >> >> local all all trust >> host all all 192.168.2.0 255.255.255.0 trust >> >> I couldnt understand why. Please shed some light > This is not the default configuration, so I suspect that you changed it. ... and forgot to SIGHUP the postmaster after changing it, so the original IDENT-based selection is still active. Do "pg_ctl reload" to get the postmaster to notice changes in its config files. regards, tom lane