Re: 8.0 Beta 1 // Environment Vars // .pgpass
Andrew Dunstan <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Joerg Hessdoerfer wrote: >On Thursday 12 August 2004 06:25, Tom Lane wrote: > > >>"efesar (the kay)" <[email protected]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [email protected])