PostgreSQL Anonymizer 2.3 : Replica Masking

NewsBot · 7 July 2025 05:29

A new PostgreSQL blog post/announcement has been posted!

Eymoutiers, France, July 2nd, 2025

We're publishing PostgreSQL Anonymizer 2.3 today, introducing the long awaited replica masking mechanism. Database Administrators can now synchronize a "masked clone" with their production database using PostgreSQL logical replication.

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

Replica Masking - Anonymized logical replication

Backup Masking - 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 be 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, etc.

See the https://www.postgresql.org/about/news/postgresql-anonymizer-23-replica-masking-3099/