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).

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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org