Aiven for PostgreSQL® now supports the postgresql_anonymizer extension, which masks or replaces personally identifiable information (PII) or commercially sensitive data in a PostgreSQL database.
PostgreSQL Anonymizer enables you to:
- Comply with privacy regulations: By masking or replacing sensitive data (PII).
- Safely use data in non-production environments: You can work with realistic, yet anonymized, datasets.
- Apply various masking strategies: Including static (permanent), dynamic (real-time, role-based), and anonymous data dumps.
- Define masking rules directly in SQL: Making it a declarative and integral part of the database schema.
- Generate fake but realistic data: For more effective testing and development.
Learn how to use postgresql_anonymizer on Aiven in Extensions on Aiven for PostgreSQL® > Utilities.