On Sunday 21 April 2002 09:35, Gunnar wrote: > 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
I think that postgres only uses the first line and that line says that postgres uses the ident autentication (without a password if the user is the same). This means that the user MUST exist in the /etc/passwd. The second line (not used because the first is the same) allows al users without a password. So remove the first line or add user to passwd. Ferdinand ---------------------------(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
