psql: FATAL 1: IDENT authentication failed for user "postgres"
i know this is a know problem, but i cant seem to get it right
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 ?