On Tue, Aug 19, 2003 at 09:50:33 -0600, "scott.marlowe" <scott.marlowe@xxxxxxx> 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.
