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

From Denny-Schierz
Subject Linux user www-data has no access to amphora2 DB
Date
Msg-id 19237774917.20020422193259@gmx.de
Whole thread Raw
Responses Re: Linux user www-data has no access to amphora2 DB  (David Stanaway <david@stanaway.net>)
Re: Linux user www-data has no access to amphora2 DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@gmx.de


pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: An Analyze question
Next
From: Tom Lane
Date:
Subject: Re: An Analyze question