i know this is a know problem, but i cant seem to get it right

i do:

psql -d template1 -f pgsql_create.sql -U postgres psql: FATAL 1: IDENT authentication failed for user "postgres"


in my pg_hba.conf i have

local all ident sameuser
host all 127.0.0.1 255.0.0.0 ident sameuser
host all 0.0.0.0 0.0.0.0 reject


i have also had:

local all all ident sameuser

but same problem...i did restart postgresql every time...what is wrong ?

-k

The things you posted don't state it, so I'll ask
the most obvious thing first:

You're actually logged in as the user postgres
when you do this?


Cheers,
Tink

hehe...it worked with su - postgres...but i also need the following :

# psql -d horde -U horde -f auth.sql
# psql -d horde -U horde -f category.sql
# psql -d horde -U horde -f prefs.sql


but when i try that i get:

xxx:~# su - horde
Unknown id: horde
xxx:~# psql -d horde -U horde -f auth.sql
psql: FATAL 1: IDENT authentication failed for user "horde"
xxx:~#

Do i need to add a user horde....why cant just any user connet ?


-k

because of You're telling postgres to only accept users that
exist in Linux, and that they need the Linux password.