pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLocation of pgpass.conf File
3+ messages / 3 participants
[nested] [flat]
* Location of pgpass.conf File
@ 2005-08-30 23:51 Lane Van Ingen <lvaningen@esncc.com>
2005-08-31 00:49 ` Re: Location of pgpass.conf File Jeff Frost <jeff@frostconsultingllc.com>
2005-08-31 00:59 ` Re: Location of pgpass.conf File Marko Kreen <marko@l-t.ee>
0 siblings, 2 replies; 3+ messages in thread
From: Lane Van Ingen @ 2005-08-30 23:51 UTC (permalink / raw)
To: 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).
----------------------------------------------------------------------------
----------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Location of pgpass.conf File
2005-08-30 23:51 Location of pgpass.conf File Lane Van Ingen <lvaningen@esncc.com>
@ 2005-08-31 00:49 ` Jeff Frost <jeff@frostconsultingllc.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jeff Frost @ 2005-08-31 00:49 UTC (permalink / raw)
To: Lane Van Ingen <lvaningen@esncc.com>; +Cc: 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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Location of pgpass.conf File
2005-08-30 23:51 Location of pgpass.conf File Lane Van Ingen <lvaningen@esncc.com>
@ 2005-08-31 00:59 ` Marko Kreen <marko@l-t.ee>
1 sibling, 0 replies; 3+ messages in thread
From: Marko Kreen @ 2005-08-31 00:59 UTC (permalink / raw)
To: Lane Van Ingen <lvaningen@esncc.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-31 00:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-30 23:51 Location of pgpass.conf File Lane Van Ingen <lvaningen@esncc.com>
2005-08-31 00:49 ` Jeff Frost <jeff@frostconsultingllc.com>
2005-08-31 00:59 ` Marko Kreen <marko@l-t.ee>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox