Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 309809FB854 for ; Thu, 24 May 2007 03:31:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 44320-05 for ; Thu, 24 May 2007 03:31:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc2-s30.bay0.hotmail.com (bay0-omc2-s30.bay0.hotmail.com [65.54.246.166]) by postgresql.org (Postfix) with ESMTP id BBC3F9FB816 for ; Thu, 24 May 2007 03:31:40 -0300 (ADT) Received: from hotmail.com ([207.46.11.115]) by bay0-omc2-s30.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 23 May 2007 23:31:39 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 23 May 2007 23:31:39 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Thu, 24 May 2007 06:31:35 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: From: "Vishal Arora" To: fmfpaiva@hotmail.com Cc: pgsql-admin@postgresql.org Subject: Re: Date: Thu, 24 May 2007 06:31:35 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 24 May 2007 06:31:39.0414 (UTC) FILETIME=[2F804360:01C79DCD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.027 tagged_above=0 required=5 tests=AWL=-0.768, BAYES_05=-1.11, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0, SUBJ_ALL_CAPS=0.997 X-Spam-Level: * X-Archive-Number: 200705/256 X-Sequence-Number: 25576 If you are using windows, it's under "%APPDATA%\postgresql\pgpass.conf" (where %APPDATA% refers to the Application Data subdirectory in the windows user's profile and not the postgres user. >From: "filipe paiva" >To: pgsql-admin@postgresql.org >CC: pgsql-bugs@postgresql.org >Subject: [ADMIN] >Date: Thu, 24 May 2007 07:09:56 +0100 > >I already had done this but it seems the "Store password" function stores >the password in a file other than the pgpass.conf because it really stores >passwords with or without that file. > >Can anyone tell me if it is possible to set the "Store password" option in >a file? Because if it isn't possible I should give up to look for the way >the passwords are stored... > > >>From: Joshua Kramer >>To: filipe paiva >>CC: pgsql-bugs@postgresql.org, pgsql-admin@postgresql.org >>Subject: Re: [ADMIN] >>Date: Wed, 23 May 2007 10:35:35 -0400 (EDT) >> >> >>>I already found that it's possible to store passwords in the file >>>pgpass.conf in the %APPDATA% directory. But that file isn't stored in >>>that location. In fact it doesn't exist in my disk. I already checked the >>>"Store password" >> >>Filipe, >> >>You need to create that file yourself. Using the format you found in the >>documentation, you can put your login information in the .pgpass file in >>the user's home directory, or under windows it's under >>"%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the >>Application Data subdirectory in the user's profile)." [1] >> >>Hope that helps! >> >> >>Cheers, >>-J >> >>[1] http://developer.postgresql.org/pgdocs/postgres/libpq-pgpass.html >> > >_________________________________________________________________ >Partilhe ficheiros sem depender de pombos-correios! >http://www.communicationevolved.com/pt-pt/ > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Have you searched our list archives? > > http://archives.postgresql.org _________________________________________________________________ PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507