postgresbugs <[EMAIL PROTECTED]> writes:
I would like to recommend removing the deprecation flag from PGPASSWORD.
Do you understand why it's deprecated? It's because on some operating systems, everyone on the machine can see your environment variable values (if they know how to look). We cannot prevent that.
Assuming that you can't tweak .pgpass (for example, you're just propagating a password you interactively got from the user), what's the recommended way to provide the password?
The solution I've seen elsewhere is to pass it on an additional FD that's specified in a command-line option ("--password-fd=4"). But AFAIK the postgres tools don't support this.
-O
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
