Re: authentication failed - Mailing list pgsql-general

From Tom Lane
Subject Re: authentication failed
Date
Msg-id 20213.1071764907@sss.pgh.pa.us
Whole thread Raw
In response to authentication failed  (roboccc@t-online.de (Bogdan Chytrek))
List pgsql-general
roboccc@t-online.de (Bogdan Chytrek) writes:
> So why does the authentication fail?

Because the PHP script is not running as Unix user bchytrek (most likely
that process runs under some daemon userid or other).  When you are
using IDENT authentication, your Unix user name has to match your
Postgres user name.

You could possibly work around that by creating an IDENT map that allows
the PHP daemon user to be accepted as bchytrek; see the admin guide for
details.  But more likely you'll just want to switch to a different
authentication method.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: Function Returning SETOF Problem
Next
From: Richard Huxton
Date:
Subject: Re: pqReadData() -- read() failed: errno=32