Re: Linux user www-data has no access to amphora2 DB

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denny-Schierz <cuall(at)gmx(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Linux user www-data has no access to amphora2 DB
Date: 2002-04-22 17:56:44
Message-ID: 17714.1019498204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Denny-Schierz <cuall(at)gmx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-04-22 19:53:24 Re: An Analyze question
Previous Message David Stanaway 2002-04-22 17:51:18 Re: Linux user www-data has no access to amphora2 DB