Redacting params in PostgreSQL logs

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Redacting params in PostgreSQL logs
Дата
Msg-id BY2PR0701MB2056D4FD69A96393A1D21AEBA5A10@BY2PR0701MB2056.namprd07.prod.outlook.com
обсуждение исходный текст
Ответы Re: Redacting params in PostgreSQL logs
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Thiemo Kellner
Дата:
Сообщение: Re: dblink: could not send query: another command is already inprogress
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Redacting params in PostgreSQL logs