pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16451: .psql_history file shows clear text password.
2+ messages / 2 participants
[nested] [flat]
* BUG #16451: .psql_history file shows clear text password.
@ 2020-05-18 09:17 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-05-18 09:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: abcxiaod@126.com
The following bug has been logged on the website:
Bug reference: 16451
Logged by: yi Ding
Email address: abcxiaod@126.com
PostgreSQL version: 10.12
Operating system: linux
Description:
bash-4.2# cat /home/postgres/.psql_history |grep password
alter user t password 'adsf123asg';
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16451: .psql_history file shows clear text password.
@ 2020-05-18 09:46 Magnus Hagander <magnus@hagander.net>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Magnus Hagander @ 2020-05-18 09:46 UTC (permalink / raw)
To: abcxiaod@126.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Mon, May 18, 2020 at 11:42 AM PG Bug reporting form <
noreply@postgresql.org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16451
> Logged by: yi Ding
> Email address: abcxiaod@126.com
> PostgreSQL version: 10.12
> Operating system: linux
> Description:
>
> bash-4.2# cat /home/postgres/.psql_history |grep password
> alter user t password 'adsf123asg';
>
Yes, if you intentionally send the query in clear text, it will be logged
in clear text.
Just like with your report about creating user, it is clearly documented in
the ALTER ROLE documentation that if you don't want this, you should use
\password or a similar functionality, and not the cleartext ALTER USER.
You can also turn off command line history in psql if you want, by running
it with -n.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-05-18 09:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-18 09:17 BUG #16451: .psql_history file shows clear text password. PG Bug reporting form <noreply@postgresql.org>
2020-05-18 09:46 ` Magnus Hagander <magnus@hagander.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox