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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Gunnar > Sent: Sunday, April 21, 2002 2:35 AM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
