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" <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
CC: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
To: filipe paiva <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], 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 Magazines 2007 editors choice for best Web mailaward-winning Windows
Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
