pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Location 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>
  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-31 00:49  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Lane Van Ingen <lvaningen@esncc.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-31 00:59  Marko Kreen <marko@l-t.ee>
  parent: Lane Van Ingen <lvaningen@esncc.com>
  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