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: | Re: Redacting params in PostgreSQL logs |
Date: | 2018-03-30 18:03:54 |
Message-ID: | BY2PR0701MB2056F9F8450F6A62BCDA578FA5A10@BY2PR0701MB2056.namprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
https://github.com/lfittl/pg_query/blob/master/README.md#parsing-a-normalized-query
OK found this :)
Regards,
Vijay
________________________________
From: Vijaykumar Jain
Sent: Friday, March 30, 2018 11:24:30 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Redacting params in PostgreSQL logs
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vijaykumar Jain | 2018-03-31 09:53:54 | Re: Redacting params in PostgreSQL logs |
Previous Message | Vijaykumar Jain | 2018-03-30 17:54:30 | Redacting params in PostgreSQL logs |