Re: pg_stat_statements showing passwords while create or alter users.

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: pg_stat_statements showing passwords while create or alter users.
Дата
Msg-id CAH503wDX-=iq-09RfN0v3cF0WTDqBFvqDDSc7JBsnXCziTqANQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stat_statements showing passwords while create or alter users.  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
On Fri, 17 Apr 2020 at 03:50, PG Doc comments form <noreply@postgresql.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

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: PDF documentation bug: different table columns overlap and are unreadable
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: PDF documentation bug: different table columns overlap and areunreadable