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
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
-----------------------------------------------------------------



Re: psql: FATAL 1: IDENT authentication failed for user error

From
Devrim GUNDUZ
Date:
-----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