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

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Kumar <sgnerd(at)yahoo(dot)com(dot)sg>
Cc: psql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql: FATAL 1: IDENT authentication failed for user error
Date: 2004-03-19 14:23:10
Message-ID: Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-19 15:10:05 Re: inverse of "day of year"
Previous Message Robert Creager 2004-03-19 13:47:14 Re: inverse of "day of year"