pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #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