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 B8E5BD822C for ; Tue, 6 Sep 2005 15:47:27 -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 44760-10 for ; Tue, 6 Sep 2005 18:47:21 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id A6826D79DB for ; Tue, 6 Sep 2005 15:47:21 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 06 Sep 2005 14:48:20 -0400 X-IronPort-AV: i="3.96,172,1122868800"; d="scan'208"; a="4690216:sNHT4501951512" Received: from alvh.no-ip.org (216.155.78.140) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4317C6340007F505; Tue, 6 Sep 2005 14:47:20 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id C8B22C2DC74; Tue, 6 Sep 2005 14:48:11 -0400 (CLT) Date: Tue, 6 Sep 2005 14:48:11 -0400 From: Alvaro Herrera To: Eric Emerton Cc: pgsql-admin@postgresql.org Subject: Re: Windows pgpass Problems.. Message-ID: <20050906184811.GI26068@surnet.cl> Mail-Followup-To: Eric Emerton , pgsql-admin@postgresql.org References: <41A1CBC76FDECC42B67946519C6677A902BC0869@pippin.int.etrials.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41A1CBC76FDECC42B67946519C6677A902BC0869@pippin.int.etrials.com> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.312 required=5 tests=[AWL=-0.464, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200509/47 X-Sequence-Number: 18784 On Tue, Sep 06, 2005 at 11:24:45AM -0400, 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.. Which program fails, and how does it fail? You have the correct permissions on the file, I presume? The file should not be readable nor writable by anyone but the owner; and I assume the directory where it resides, shouldn't either (In fact I'd check every directory up in the path.) -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com "Entristecido, Wutra (canción de Las Barreras) echa a Freyr a rodar y a nosotros al mar"