Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 283D7650040 for ; Mon, 15 Sep 2008 14:41:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27853-01-3 for ; Mon, 15 Sep 2008 14:41:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fileserver.binf.ku.dk (174.binf.ku.dk [130.225.125.174]) by postgresql.org (Postfix) with ESMTP id 3841F64FD36 for ; Mon, 15 Sep 2008 14:41:40 -0300 (ADT) Received: from localhost (firewall.binf.ku.dk [10.10.0.254]) by fileserver.binf.ku.dk (Postfix) with ESMTP id F1377E470E; Mon, 15 Sep 2008 19:41:37 +0200 (CEST) Received: from localhost ([10.10.3.17] helo=localhost) by ASSP; 15 Sep 2008 19:41:37 +0200 Date: Mon, 15 Sep 2008 19:41:37 +0200 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Trouble setting up access privileges Message-ID: <20080915174137.GB16666@optiplex36> References: <20080915154340.GA15530@optiplex36> <508.1221498488@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <508.1221498488@sss.pgh.pa.us> User-Agent: Mutt/1.5.13 (2006-08-11) From: mkrist@binf.ku.dk X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/137 X-Sequence-Number: 30230 On Mon, Sep 15, 2008 at 01:08:08PM -0400, Tom Lane wrote: ... > forgot to SIGHUP the postmaster, (4) you have a ~/.pgpass file on > the client side that is silently supplying a password in some of > these cases. It seems the user had this ~/.pgpass file and that this was the reason. Thanks for pointing out the possibility. Why isn't this ~/.pgpass file documented in http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html ? Again, thank you, I appreciate it. -- Michael Kristensen IT-studentermedhj?lper / Sysadm student aid BINF