Linux user www-data has no access to amphora2 DB

From: Denny-Schierz <cuall(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Linux user www-data has no access to amphora2 DB
Date: 2002-04-22 17:32:59
Message-ID: 19237774917.20020422193259@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi pgsql-admin,

i want to install the amphora2 light groupware software under Debian Woody
with pgsql 7.2.1. I have to restore a dump into the amphora2 DB that
i created before.:
-----------------
testlinux:/home/amphora2/inst# su www-data -s /bin/bash -c 'psql amphora2 < amphora2.0.dump'
-----------------

but postgres tells me:

-----------------
psql: FATAL 1: IDENT authentication failed for user "www-data"
-----------------

my pg_hba.conf:

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

--
Mit freundlichen Grüssen
Denny-Schierz mailto:cuall(at)gmx(dot)de

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-04-22 17:40:21 Re: An Analyze question
Previous Message Nick Fankhauser 2002-04-22 17:24:27 Re: An Analyze question