Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CFB1A9FBC44; Thu, 24 May 2007 03:10:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 69282-06; Thu, 24 May 2007 03:10:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s19.bay0.hotmail.com (bay0-omc3-s19.bay0.hotmail.com [65.54.246.219]) by postgresql.org (Postfix) with ESMTP id 37CCB9FBC18; Thu, 24 May 2007 03:10:01 -0300 (ADT) Received: from hotmail.com ([64.4.39.93]) by bay0-omc3-s19.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 23 May 2007 23:10:00 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 23 May 2007 23:09:59 -0700 Message-ID: Received: from 64.4.39.123 by by140fd.bay140.hotmail.msn.com with HTTP; Thu, 24 May 2007 06:09:56 GMT X-Originating-IP: [62.121.58.37] X-Originating-Email: [fmfpaiva@hotmail.com] X-Sender: fmfpaiva@hotmail.com In-Reply-To: From: "filipe paiva" To: pgsql-admin@postgresql.org Cc: pgsql-bugs@postgresql.org Date: Thu, 24 May 2007 07:09:56 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 24 May 2007 06:09:59.0866 (UTC) FILETIME=[28E8F9A0:01C79DCA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.251 tagged_above=0 required=5 tests=AWL=0.127, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MISSING_SUBJECT=1.816, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200705/255 X-Sequence-Number: 25575 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/