Re: PGPASSWORD

Tom Lane wrote:
> postgresbugs <postgresbugs@grifent.com> 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