X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8B57FD1B9A3 for ; Tue, 19 Aug 2003 12:58:10 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85633-09 for ; Tue, 19 Aug 2003 12:57:59 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 147C0D1B998 for ; Tue, 19 Aug 2003 12:57:59 -0300 (ADT) Received: (qmail 20235 invoked by uid 500); 19 Aug 2003 16:03:42 -0000 Date: Tue, 19 Aug 2003 11:03:42 -0500 From: Bruno Wolff III To: "scott.marlowe" Cc: dash@melchior.rogue-penguin.com, pgsql-php@postgresql.org Subject: Re: Authentication Failure with pg_pconnect Message-ID: <20030819160342.GE18374@wolff.to> Mail-Followup-To: "scott.marlowe" , dash@melchior.rogue-penguin.com, pgsql-php@postgresql.org References: <34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/81 X-Sequence-Number: 2258 On Tue, Aug 19, 2003 at 09:50:33 -0600, "scott.marlowe" 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.