Denny-Schierz <[EMAIL PROTECTED]> writes:
> testlinux:/home/amphora2/inst# su www-data -s /bin/bash -c 'psql amphora2 <
>amphora2.0.dump'
> psql: FATAL 1: IDENT authentication failed for user "www-data"
> local amphora2 ident amphora
> 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
Did you provide an ident map called amphora? If so, what users does it
accept?
I suspect you really want to remove that first pg_hba line, and let the
"ident sameuser" policy apply to local connections to all databases.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
