[ADMIN] pgaudit/Password Redaction - Mailing list pgsql-admin

From Dale,Bob
Subject [ADMIN] pgaudit/Password Redaction
Date
Msg-id 5d773038fb434dbd99969b62575fd43a@pvnva7xm00.Vanguard.com
Whole thread Raw
List 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.

pgsql-admin by date:

Previous
From: Gokhan Demir
Date:
Subject: Re: [ADMIN] PostgreSQL WAL file issue
Next
From: Debraj Manna
Date:
Subject: [ADMIN] Upgrading postgres to 10 from 9.5 using pg_upgradecluster