pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Devrim GUNDUZ <devrim@gunduz.org>
To: Kumar <sgnerd@yahoo.com.sg>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: psql: FATAL 1: IDENT authentication failed for user  error
Date: Fri, 19 Mar 2004 16:23:10 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr> (raw)
In-Reply-To: <026601c40daf$442ffcd0$7502a8c0@hdsc.com>

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




view thread (4+ messages)  latest in thread

Message-ID: <Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr>
Permalink:  ../Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: devrim@gunduz.org, sgnerd@yahoo.com.sg
  Subject: Re: psql: FATAL 1: IDENT authentication failed for user  error
  In-Reply-To: <Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox