pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
password saved in .psql_history
2+ messages / 2 participants
[nested] [flat]

* password saved in .psql_history
@ 2020-08-25 20:29 hans.wolters <hans.wolters@protonmail.com>
  2020-08-25 21:39 ` Re: password saved in .psql_history Alvaro Herrera <alvherre@2ndquadrant.com>
  0 siblings, 1 reply; 2+ messages in thread

From: hans.wolters @ 2020-08-25 20:29 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Dear all,
I noticed the password of a used is stored in the history of the psql user (postgres in my case). This happens when alter user <user> with password '<password>' is used.
I suppose it is not a real bug but it might be handy to filter that for things like a history listing.
Best regards,
Hans Wolters

Sent with ProtonMail Secure Email.
-----BEGIN PGP SIGNATURE-----
Version: ProtonMail

wsBzBAEBCAAGBQJfRXSsACEJEAG7dXauaxBGFiEEDDLxCO8Yjfa/PGZNAbt1
dq5rEEYQIAgAlfySOp7MWvK9G3NeOL3No0JcHwpZ9l5WGDU+59S+Cx55YEul
CXfIzjFw9uBvd3RO/GZsKnlyz5iuY2XE/XvTz3skxlcam18wA2eybB3AWhNc
LqaJw58lNoVPLofQjbgnNcMjw9qOioa5b+syJaOHh+BJVIKquASTDUcOckF4
NE+YKeGKnu4nP9RLeojkvtWdc0CmJN58BP6lLmOiLSwIDj4LmWT8Jrdnbdwj
ggM9UFPkn+AjBjJVYSrZlGVn2WL04rpPkjzGlea8hkLu2mqZFUDSd3aVN5Fy
4bvolUnc9iXFeC8k0O+odHXpR/uWhdApfPpU4LtuAY+yZc1uzxHI3g==
=JsgG
-----END PGP SIGNATURE-----

Attachments:

  publickey - hans.wolters@protonmail.com - 0x0C32F108.asc (application/pgp-keys, 1.8K) download

  publickey - hans.wolters@protonmail.com - 0x0C32F108.asc.sig (application/pgp-signature, 310B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: password saved in .psql_history
  2020-08-25 20:29 password saved in .psql_history hans.wolters <hans.wolters@protonmail.com>
@ 2020-08-25 21:39 ` Alvaro Herrera <alvherre@2ndquadrant.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2020-08-25 21:39 UTC (permalink / raw)
  To: hans.wolters <hans.wolters@protonmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

On 2020-Aug-25, hans.wolters wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
> 
> Dear all,
> I noticed the password of a used is stored in the history of the psql user (postgres in my case). This happens when alter user <user> with password '<password>' is used.
> I suppose it is not a real bug but it might be handy to filter that for things like a history listing.

This is why you should use \password in psql instead of 'alter user ..
password'.  (Well, that and the server log and risk of unencrypted
password traffic.)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-08-25 21:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-25 20:29 password saved in .psql_history hans.wolters <hans.wolters@protonmail.com>
2020-08-25 21:39 ` Alvaro Herrera <alvherre@2ndquadrant.com>

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