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" <fmfpaiva@hotmail.com>
>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 <josh@globalherald.net>
>>To: filipe paiva <fmfpaiva@hotmail.com>
>>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