psql: FATAL 1: IDENT authentication failed for user "postgres"

linuxtesting2 · 06-15-2004, 04:46 PM

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

Tinkster · 06-15-2004, 06:15 PM

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

linuxtesting2 · 06-16-2004, 04:58 AM

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

Tinkster · 06-16-2004, 12:48 PM

because of

Quote:

ident sameuser

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