Postgres Pro
Downloads
Home   >   mailing lists

Redacting params in PostgreSQL logs - Mailing list pgsql-general

From Vijaykumar Jain
Subject Redacting params in PostgreSQL logs
Date
Msg-id BY2PR0701MB2056D4FD69A96393A1D21AEBA5A10@BY2PR0701MB2056.namprd07.prod.outlook.com
Whole thread Raw
Responses Re: Redacting params in PostgreSQL logs  (Vijaykumar Jain <vjain@opentable.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Thiemo Kellner
Date:
Subject: Re: dblink: could not send query: another command is already inprogress
Next
From: Vijaykumar Jain
Date:
Subject: Re: Redacting params in PostgreSQL logs