| Lists: | pgsql-admin |
|---|
| From: | "Lane Van Ingen" <lvaningen(at)esncc(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Location of pgpass.conf File |
| Date: | 2005-08-30 23:51:58 |
| Message-ID: | EKEMKEFLOMKDDLIALABIMEAMCCAA.lvaningen@esncc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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).
----------------------------------------------------------------------------
----------------------
| From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
|---|---|
| To: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Location of pgpass.conf File |
| Date: | 2005-08-31 00:49:29 |
| Message-ID: | Pine.LNX.4.63.0508301747130.14399@discord.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
| From: | Marko Kreen <marko(at)l-t(dot)ee> |
|---|---|
| To: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Location of pgpass.conf File |
| Date: | 2005-08-31 00:59:51 |
| Message-ID: | 20050831005951.GA18690@l-t.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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