Re: Linux user www-data has no access to amphora2 DB - Mailing list pgsql-admin

Denny-Schierz <cuall@gmx.de> 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