From: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
To: fmfpaiva(at)hotmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re:
Date: 2007-05-24 06:31:35
Message-ID: BAY123-F35697FE7B168D46CF34F5FA9340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-bugs

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(at)hotmail(dot)com>
>To: pgsql-admin(at)postgresql(dot)org
>CC: pgsql-bugs(at)postgresql(dot)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(at)globalherald(dot)net>
>>To: filipe paiva <fmfpaiva(at)hotmail(dot)com>
>>CC: pgsql-bugs(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)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"
>>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!
>Partilhe ficheiros sem depender de pombos-correios!
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?

PC Magazines 2007 editors choice for best Web mailaward-winning Windows
Live Hotmail.

In response to

  • at 2007-05-24 06:09:56 from filipe paiva

Browse pgsql-admin by date

  From Date Subject
Next Message Vishal Arora 2007-05-24 06:38:34 Re: how to view all database,tables,users
Previous Message filipe paiva 2007-05-24 06:09:56

Browse pgsql-bugs by date

  From Date Subject
Next Message Purusothaman A 2007-05-24 10:45:34 BUG #3303: Postgresql damages file objects when it grows with more file objects.
Previous Message filipe paiva 2007-05-24 06:09:56