Postgres Pro
Downloads
Home   >   mailing lists

Thread: Location of pgpass.conf File

Location of pgpass.conf File

From
"Lane Van Ingen"
Date:
Can somebody tell me (on Windows 2003) where the 'application subdirectory
in the user's profile' is? I want to set up a pgpass.conf file. Nothing has
worked so far. I am on version 8.0.0.

---------------------- from the PostgreSQL
Documentation -----------------------------------------

The file .pgpass in a user's home directory is a file that can contain
passwords to be used if the connection requires a password (and no password
has been specified otherwise). On Microsoft Windows the file is named
%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application
Data subdirectory in the user's profile).

----------------------------------------------------------------------------
----------------------

Re: Location of pgpass.conf File

From
Jeff Frost
Date:
Lane, %APPDATA% is an environment variable in Windows systems that refers to
the Application Data Subdir.  It can differ depending on install options, so
you can find out for yourself, by just opening a CMD shell and doing the
following:

echo %appdata%

or even:

cd %appdata%

On my XP system, it looks like this:

C:\>echo %appdata%
C:\Documents and Settings\jeff\Application Data

C:\>cd %appdata%

C:\Documents and Settings\jeff\Application Data>

On Tue, 30 Aug 2005, Lane Van Ingen wrote:

> %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application
> Data subdirectory in the user's profile).

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

Re: Location of pgpass.conf File

From
Marko Kreen
Date:
On Tue, Aug 30, 2005 at 07:51:58PM -0400, Lane Van Ingen wrote:
> Can somebody tell me (on Windows 2003) where the 'application subdirectory
> in the user's profile' is? I want to set up a pgpass.conf file. Nothing has
> worked so far. I am on version 8.0.0.
>
> ---------------------- from the PostgreSQL
> Documentation -----------------------------------------
>
> The file .pgpass in a user's home directory is a file that can contain
> passwords to be used if the connection requires a password (and no password
> has been specified otherwise). On Microsoft Windows the file is named
> %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application
> Data subdirectory in the user's profile).
>
> ----------------------------------------------------------------------------
> ----------------------

My guess:

\Documents and Settings\$USER\Application Data

--
marko