pgaudit/Password Redaction

From: "Dale,Bob" <bob_dale(at)vanguard(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pgaudit/Password Redaction
Date: 2017-11-10 20:02:30
Message-ID: 5d773038fb434dbd99969b62575fd43a@pvnva7xm00.Vanguard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Issue with pgaudit (Postgresql 9.6.3). When a syntax issue fail of a CREATE ROLE or ALTER ROLE commands happens the PASSWORD clause is reflected in the pgaudit output. No redaction.
Does anyone know of a way to 'configure out' the echo of the command buffer on a syntax fail? Passwords are not being redacted in this case.

Thanks
Bob
CONFIDENTIALITY STATEMENT. The information contained in this e-mail message, including attachments, is the confidential information of, and/or is the property of, Vanguard. The information is intended for use solely by the individual or entity named in the message. If you are not an intended recipient or you received this in error, then any review, printing, copying, or distribution of any such information is prohibited, and please notify the sender immediately by reply e-mail and then delete this e-mail from your system.

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2017-11-11 02:32:19 Upgrading postgres to 10 from 9.5 using pg_upgradecluster
Previous Message Gokhan Demir 2017-11-10 15:01:44 Re: PostgreSQL WAL file issue