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