Re: psql: FATAL 1: IDENT authentication failed for user error - Mailing list pgsql-sql

From Devrim GUNDUZ
Subject Re: psql: FATAL 1: IDENT authentication failed for user error
Date
Msg-id Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr
Whole thread Raw
In response to psql: FATAL 1: IDENT authentication failed for user error - Urgent pls  ("Kumar" <sgnerd@yahoo.com.sg>)
List pgsql-sql
-----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-----



pgsql-sql by date:

Previous
From: Robert Creager
Date:
Subject: Re: inverse of "day of year"
Next
From: Tom Lane
Date:
Subject: Re: inverse of "day of year"