Re: 8.0 Beta 1 // Environment Vars // .pgpass - Mailing list pgsql-hackers-win32

From Joerg Hessdoerfer
Subject Re: 8.0 Beta 1 // Environment Vars // .pgpass
Date
Msg-id 200408131457.26663.Joerg.Hessdoerfer@sea-gmbh.com
Whole thread Raw
In response to Re: 8.0 Beta 1 // Environment Vars // .pgpass  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.0 Beta 1 // Environment Vars // .pgpass  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers-win32
On Thursday 12 August 2004 06:25, Tom Lane wrote:
> "efesar (the kay)" <efesar@unm.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 ...
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

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?

Greetings,
    Joerg
--
Leading SW developer  - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com

pgsql-hackers-win32 by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: [GENERAL] error moving table to tablespace
Next
From: Andrew Dunstan
Date:
Subject: Re: 8.0 Beta 1 // Environment Vars // .pgpass