X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5C0ED87F0 for ; Tue, 6 Sep 2005 17:57:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82746-03 for ; Tue, 6 Sep 2005 20:57:28 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 1C8BDD8938 for ; Tue, 6 Sep 2005 17:57:27 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 06 Sep 2005 15:57:29 -0500 Subject: Re: Windows pgpass Problems.. From: Scott Marlowe To: Eric Emerton Cc: pgsql-admin@postgresql.org In-Reply-To: <41A1CBC76FDECC42B67946519C6677A902BC0869@pippin.int.etrials.com> References: <41A1CBC76FDECC42B67946519C6677A902BC0869@pippin.int.etrials.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1126040249.28179.191.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 06 Sep 2005 15:57:29 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200509/50 X-Sequence-Number: 18787 On Tue, 2005-09-06 at 10:24, Eric Emerton wrote: > I have been stuggling all day with the pgpass ability on 8.0 Postgres - on Windows 2000. I have been to the documentation: After reading many threads on similar problems, I just cannot seem to get a batch file to recognize that pgpass is there. I have dropped it into the Application data directory postgresql\pgpass.conf of 'Administrator', (My windows username), 'postgres', 'All Users', etc, etc. The contents I have tried for the pgpass file areeach of the combinations of: > > localhost:5432::: > 127.0.0.1:5432::: > localhost:*::: > 127.0.0.1:*::: > ..and many others > > has been postgres and other test superuser accounts. Nothing seems to work. I have restarted postgres, restarted windows, and it simply wont take.. Has it been set to be readable only by the given user who is using it?