Skip site navigation (1) Skip section navigation (2)

Re: 8.0 Beta 1 // Environment Vars // .pgpass

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: 8.0 Beta 1 // Environment Vars // .pgpass
Date: 2004-08-13 13:20:30
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers-win32pgsql-patches

Joerg Hessdoerfer wrote:

>On Thursday 12 August 2004 06:25, Tom Lane wrote:
>>"efesar (the kay)" <efesar(at)unm(dot)edu> writes:
>>>The 8.0 version does not acknowledge env vars like PGPASSWORD and seems
>>>to ignore the contents of the .pgpass file.
>>Hmmm.   Those are probably the same problem, since finding .pgpass
>>depends on expanding the $HOME env var.  But I have no idea why
>>env vars aren't working for you ...
>Yep. AFAIK, $HOME doesn't always exist in WIN32, but $HOMEDRIVE and $HOMEPATH 
>(or %HOMEPATH% and %HOMEDRIVE% ;-) do. Perhaps PG needs to do some munging to 
>build the home path from those two?

On my XP-Pro machine the appropriate setting appears to be %USERPROFILE% 
- %HOMEPATH% is just "\"

See here for a complete list of available environment vars:



In response to


pgsql-patches by date

Next:From: Peter EisentrautDate: 2004-08-13 16:34:38
Subject: Re: Translation updates for 8.0: pg_controldata-ru, pg_resetxlog-ru, pgscripts-ru
Previous:From: Bruce MomjianDate: 2004-08-13 13:17:37
Subject: Re: [BUGS] 8.0.0beta1: -lpthread missing

pgsql-hackers-win32 by date

Next:From: Rodrigo MorenoDate: 2004-08-13 13:44:00
Subject: REPOST: InitDB Failure on install
Previous:From: Joerg HessdoerferDate: 2004-08-13 12:57:26
Subject: Re: 8.0 Beta 1 // Environment Vars // .pgpass

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group