Redacting params in PostgreSQL logs

From: Vijaykumar Jain <vjain(at)opentable(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Redacting params in PostgreSQL logs
Date: 2018-03-30 17:54:30
Message-ID: BY2PR0701MB2056D4FD69A96393A1D21AEBA5A10@BY2PR0701MB2056.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a project of sending postgres logs to ELK stack. It is working fine.

Now there are concerns that logs have query statements with parameters.
and then GDPR and other PII issues.

Is there a way I can redact the params in statements in the logs by some config or extension ?
Pls note: I want the statements in logs but not the values :)

like insert into foo values (‘xxx’) etc

Regards,
Vijay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2018-03-30 18:03:54 Re: Redacting params in PostgreSQL logs
Previous Message Thiemo Kellner 2018-03-30 17:08:02 Re: dblink: could not send query: another command is already in progress