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: 411CC01E.5060601@dunslane.net (view raw or flat)
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:

http://www.winnetmag.com/Article/ArticleID/23873/23873.html

cheers

andrew

In response to

Responses

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-2014 The PostgreSQL Global Development Group