From: | Euler Taveira <euler(dot)taveira(at)2ndquadrant(dot)com> |
---|---|
To: | chandu_munnu(at)yahoo(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_stat_statements showing passwords while create or alter users. |
Date: | 2020-04-17 12:51:47 |
Message-ID: | CAH503wDX-=iq-09RfN0v3cF0WTDqBFvqDDSc7JBsnXCziTqANQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Fri, 17 Apr 2020 at 03:50, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:
>
> pg_stat_statements is recording passwords also, is there any way to avoid
> the logging of passwords without droping extension package.
> testdb=> create user test1 with password 'test123';
> CREATE ROLE
> testdb=> create user test2 with encrypted password 'test123';
> CREATE ROLE
> test=> select query from pg_stat_statements where query like '%test%';
> query
> -----------------------------------------------------------
> create user test1 with encrypted password 'test123'
> create user test2 with password 'test123'
>
> pg_stat_statements has parameter "pg_stat_statements.track_utility" to
control whether utility commands are tracked. It is on by default.
Regards,
--
Euler Taveira http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2020-04-17 12:57:21 | Re: PDF documentation bug: different table columns overlap and are unreadable |
Previous Message | PG Doc comments form | 2020-04-17 07:37:52 | PDF documentation bug: different table columns overlap and are unreadable |