3 ms·
> There are masking tools out there that can mask data from production Thank you so much! "Masking" was the phrase I needed to find some potential solutions! I
by penagwin 7y ago
> There are masking tools out there that can mask data from production
Thank you so much! "Masking" was the phrase I needed to find some potential solutions! I wasn't able to find much before, that points me in the correct direction. Thanks!
- rickbad68 7y agoOther common terms for this are sanitization or redaction
- samokhvalov 7y agoThere are various approaches here, and there are some FOSS tools that you can use. Some links: - https://blog.taadeem.net/english/2019/01/03/8_anonymization_strategies_with_postgres https://blog.taadeem.net/english/2019/01/03/8_anonymization_... – description of methods, and a tool for Postgres, postgresql_anonymizer - https://habr.com/en/company/yandex/blog/485096/ https://habr.com/en/company/yandex/blog/485096/ – not for Postgres, it's for ClickHouse (open-source DBMS for analytics) but covers the topic very well.