Re: [BUGS] More SSL questions..

"Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
> Excellent. I would suggest that we allow an environment variable PGHOME to
> override this on all platforms, falling back to the above on Windows and
> HOME elsewhere.

Given that this code is mainly used to find security-critical files
(.pgpass and SSL certificates), I'm not sure that an override is a good
idea. I'm not dead set against it though --- any other opinions out
there?

Also, how do we document this behavior on Windows? The libpq docs
currently talk about, eg,

the connection in <filename>$HOME/.pgpass</> (or
<filename>%USERPROFILE%\.pgpass</> on Microsoft Windows).

but I'm not sure that's accurate or useful. Is there a phrase
comparable to "home directory" that will be understood by Windows
users? I'm thinking of writing "~/.pgpass" for the Unix case to
avoid giving the impression that we depend on getenv("HOME"),
because we won't anymore.

regards, tom lane