pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16447: The query field of the pg_stat_activity table displays the clear text of the password.
2+ messages / 2 participants
[nested] [flat]

* BUG #16447: The query field of the pg_stat_activity table displays the clear text of the password.
@ 2020-05-18 09:11  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-05-18 09:11 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: abcxiaod@126.com

The following bug has been logged on the website:

Bug reference:      16447
Logged by:          yi Ding
Email address:      abcxiaod@126.com
PostgreSQL version: 10.12
Operating system:   linux
Description:        

When the administrator create a user and set the password,  we can see the
password in the pg_stat_activity table.



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

* Re: BUG #16447: The query field of the pg_stat_activity table displays the clear text of the password.
@ 2020-05-18 09:43  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:43 UTC (permalink / raw)
  To: abcxiaod@126.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

On Mon, May 18, 2020 at 11:41 AM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      16447
> Logged by:          yi Ding
> Email address:      abcxiaod@126.com
> PostgreSQL version: 10.12
> Operating system:   linux
> Description:
>
> When the administrator create a user and set the password,  we can see the
> password in the pg_stat_activity table.
>
>
Not when the administrator uses the suggested method for setting passwords.
You can use \passwd in psql or use the createuser command to avoid that.
This is clearly documented on the CREATE ROLE documentation page in the
Notes section (https://www.postgresql.org/docs/12/sql-createrole.html)

-- 
 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:43 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:11 BUG #16447: The query field of the pg_stat_activity table displays the clear text of the password. PG Bug reporting form <noreply@postgresql.org>
2020-05-18 09:43 ` 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