X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 8757CD1BAC8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Mar 2004 12:39:41 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 65253-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Mar 2004 08:39:40 -0400 (AST)
Received: from smtp106.mail.sc5.yahoo.com (smtp106.mail.sc5.yahoo.com
	[66.163.169.226])
	by svr1.postgresql.org (Postfix) with SMTP id 1ACFAD1B542
	for <pgsql-sql@postgresql.org>; Fri, 19 Mar 2004 08:39:36 -0400 (AST)
Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login)
	by smtp106.mail.sc5.yahoo.com with SMTP; 19 Mar 2004 12:39:16 -0000
Message-ID: <026601c40daf$442ffcd0$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "psql" <pgsql-sql@postgresql.org>
Subject: psql: FATAL 1: IDENT authentication failed for user error - Urgent
 pls
Date: Fri, 19 Mar 2004 18:09:33 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0263_01C40DDD.54FE9340"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/199
X-Sequence-Number: 17298

This is a multi-part message in MIME format.

------=_NextPart_000_0263_01C40DDD.54FE9340
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

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

I couldnt understand why. Please shed some light

------=_NextPart_000_0263_01C40DDD.54FE9340
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV><FONT size=3D2>Dear Friends,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I have installed Linux Fedore and wanted to work with t=
he=20
default installed postgres 7.3.4 database.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I could able to create to create user, but while try to=
=20
connect, I got the following error message</FONT></DIV>
<DIV>psql: FATAL 1: IDENT authentication failed for user </DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>My pg_hba.conf file looks like below</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2># TYPE&nbsp; DATABASE&nbsp;&nbsp;&nbsp;=20
USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
IP-ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
IP-MASK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
METHOD</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>local&nbsp;&nbsp;=20
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
trust<BR>host&nbsp;all&nbsp;&nbsp;&nbsp;&nbsp;=20
all&nbsp;&nbsp;192.168.2.0&nbsp;&nbsp; 255.255.255.0&nbsp;&nbsp;&nbsp;&nbsp=
;=20
trust <BR></FONT></DIV>
<DIV><FONT size=3D2>I couldnt understand why. Please shed some light</DIV><=
/FONT>
<P></P></BODY></HTML>

------=_NextPart_000_0263_01C40DDD.54FE9340--