PostgreSQL Anonymizer 2.1: Blurring Images

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Eymoutiers, France, April 18, 2025

PostgreSQL Anonymizer 2.1 is out and it brings new possibilities in the field of database privacy protection!

Enhanced Privacy Protection for Your Data

PostgreSQL Anonymizer is an extension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database.

The extension offers five different masking strategies:

• Dynamic Masking - Real-time data protection
• Static Masking - Permanent data transformation
• Anonymous Dumps - Privacy-protected database exports
• Masking Views - Controlled data visibility
• Masking Data Wrappers - Extended protection across systems

Each strategy is complemented by an enhanced suite of Masking Functions, including advanced techniques such as: Substitution, Randomization, Faking, Pseudonymization, Partial Scrambling, Shuffling, Noise Addition and Generalization.

The extension can installed with Debian and RPM packages, an Ansible role, a docker image, etc. It is also available on major DBaaS providers including : Alibaba Cloud, Crunchy Bridge, Google Cloud SQL, Microsoft Azure Database, Neon, Tembo

See the INSTALL section of the documentation for more details !

Image Blurring, Privacy Protection Beyond Text Data

Sensitive information doesn't just hide in obvious places.

While columns like name an...

Get the full details here: PostgreSQL: PostgreSQL Anonymizer 2.1: Blurring Images