Re: BUG #15930: Redact PGPASSWORD environment variable in psql - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15930: Redact PGPASSWORD environment variable in psql
Date
Msg-id 20190730022943.GD1742@paquier.xyz
Whole thread Raw
In response to Re: BUG #15930: Redact PGPASSWORD environment variable in psql  (Georg Sauthoff <mail@gms.tf>)
List pgsql-bugs
On Mon, Jul 29, 2019 at 08:37:39PM +0200, Georg Sauthoff wrote:
>> Having psql try to clear it out
>> seems rather pointless to me, as (a) that does nothing for instances
>> of the value that appear in the environments of ancestor processes,
>
> I don't know why you bring that up. It would only be pointless if the
> password would appear in the original environment vector of ancestor
> processes. It would also be pointless if an ancestor process would write
> it to disk. But why would you want to do that?

The point of Tom is that If PGPASSWORD is set at user level, say a
.bashrc, then you have the problem for all commands run by this user,
and not only psql, so it is a bit pointless to do that only from the
point of view of psql, because it does not address the root of the
issue.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15932: Module passwordcheck doesn't reference previous hooks
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: BUG #15923: Prepared statements take way too much memory.