Re: Authentication Failure with pg_pconnect

On Tue, Aug 19, 2003 at 09:50:33 -0600,
"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> wrote:
>
> Note that the username of the client (in this case, likely either httpd or
> nobody) is what postgresql inspects. your connection string doesn't
> matter since postgresql is now looking for a user account by the name of
> whatever user your web server runs under.

This isn't exactly true. The id given in the connection string is
the one that is to be used for the postgres connection. The username of
the client is checked to see if it is an allowed system user for the
postgres user. It is common to force them to match, but other options
are possible.