Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by postgresql.org (Postfix) with ESMTP id A49A3475CAF for ; Mon, 22 Apr 2002 08:38:36 -0400 (EDT) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id HAA31856; Mon, 22 Apr 2002 07:38:31 -0500 X-Authentication-Warning: shire.ontko.com: Host bilbo.ontko.com [199.164.165.101] claimed to be nick Reply-To: From: "Nick Fankhauser" To: , Subject: Re: Connection problem Date: Mon, 22 Apr 2002 07:37:08 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal In-Reply-To: <02042109351701.08765@fire> X-Archive-Number: 200204/195 X-Sequence-Number: 4083 Gunnar- It looks to me like the two lines in pg_hba conflict, and the first one is being used. Since you are logged in as root, it looks for "sameuser" on foobar and doesn't get a match. Try either logging into linux as foobar or eliminate the first line of pg_hba. -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Gunnar > Sent: Sunday, April 21, 2002 2:35 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Connection problem > > > I'm having problems connecting to my postgresql 7.2.1 running on > my Debian > Linux box. > > (as root) > $ psql template1 foobar > psql: FATAL 1: IDENT authentication failed for user "foobar" > > Could anybody tell me what the problem is? > The user "foobar" is created with the createuser command without > any problem. > > Here is the pg_hba.conf > > local all ident sameuser > local all trust > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >