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 45A55D8434 for ; Tue, 30 Aug 2005 22:00:21 -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 22236-09 for ; Wed, 31 Aug 2005 01:00:18 +0000 (GMT) Received: from www.lindaliini.ee (www.lindaliini.ee [212.47.213.99]) by svr1.postgresql.org (Postfix) with ESMTP id 05F68D874F for ; Tue, 30 Aug 2005 22:00:17 -0300 (ADT) Received: from grue.l-t.ee (grue [212.47.213.101]) by www.lindaliini.ee (Postfix) with ESMTP id 03CD3ECB8; Wed, 31 Aug 2005 03:58:46 +0300 (EEST) Received: by grue.l-t.ee (Postfix, from userid 1000) id A30102E3D4; Wed, 31 Aug 2005 03:59:51 +0300 (EEST) Date: Wed, 31 Aug 2005 03:59:51 +0300 From: Marko Kreen To: Lane Van Ingen Cc: pgsql-admin@postgresql.org Subject: Re: Location of pgpass.conf File Message-ID: <20050831005951.GA18690@l-t.ee> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-LT-MailScanner: No virus found X-LT-MailScanner-SpamCheck: not spam, SpamAssassin (score=-18.383, required 5, autolearn=not spam, AWL 0.22, BAYES_00 -2.60, Z_GRUE -15.00, Z_WLT -1.00) X-MailScanner-From: marko@l-t.ee X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 required=5 tests=[AWL=0.002] X-Spam-Level: X-Archive-Number: 200508/404 X-Sequence-Number: 18723 On Tue, Aug 30, 2005 at 07:51:58PM -0400, Lane Van Ingen wrote: > Can somebody tell me (on Windows 2003) where the 'application subdirectory > in the user's profile' is? I want to set up a pgpass.conf file. Nothing has > worked so far. I am on version 8.0.0. > > ---------------------- from the PostgreSQL > Documentation ----------------------------------------- > > The file .pgpass in a user's home directory is a file that can contain > passwords to be used if the connection requires a password (and no password > has been specified otherwise). On Microsoft Windows the file is named > %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application > Data subdirectory in the user's profile). > > ---------------------------------------------------------------------------- > ---------------------- My guess: \Documents and Settings\$USER\Application Data -- marko