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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-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

Browse pgsql-hackers-win32 by date

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

Browse pgsql-patches by date

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