Re: Redacting params in PostgreSQL logs

2018-03-31 Thread Vijaykumar Jain
FYI This is what I had tried wrt logstash. https://gist.github.com/cabecada/dd765a30f6946fdbf0bec0eb31fba047 From: Vijaykumar Jain Date: Friday, March 30, 2018 at 11:33 PM To: "pgsql-general@lists.postgresql.org" Subject: Re: Redacting params in PostgreSQL logs https://github.

Re: Redacting params in PostgreSQL logs

2018-03-30 Thread Vijaykumar Jain
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@lists.postgresql.org Subject: Redacting params in PostgreSQL logs

Redacting params in PostgreSQL logs

2018-03-30 Thread Vijaykumar Jain
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