Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7tSB-009DbO-4p for pgsql-announce@arkaria.postgresql.org; Thu, 24 Apr 2025 10:05:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u7tS9-00FQK5-Aw for pgsql-announce@arkaria.postgresql.org; Thu, 24 Apr 2025 10:05:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7tS8-00FQE6-0Q for pgsql-announce@lists.postgresql.org; Thu, 24 Apr 2025 10:05:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u7tS5-001gqR-1A for pgsql-announce@lists.postgresql.org; Thu, 24 Apr 2025 10:05:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Ljh0jfkmCHymuf4au5eJmKymmXxJ31ydgrLoICBxLdM=; b=jj7mjpVhc9n05Hd73gJcldhjmR npy6M8OOlEaVzkrYLXfLhWsw7xvp+8XHx0rXBFN92+HfYUdjso91jMb4wxAi6DcPQCB28C+pqIF7p Agk+aaAlY6fO6F0aCpALg2dqSHPCtNDWXcQC2StD4Eex4nCdIjv8+N5PkTr4zUrQygOMJrxQxeTsH gk4agBXfVAbng6ZGtDuycYVyP8qPWFh2BhjP6tyDLiOvi5sJvXxRq2ujYZe0sGq5P0rJmSDAp/2rS l7S6ksLzlW5YnNUicEYkIlPmQpseBDc6tRVAiznbd2ZnWE02bhina5aTO6Yvu2zdNmTbbfFdjLZo0 j0iB6Kkg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u7tS4-004kEg-07 for pgsql-announce@lists.postgresql.org; Thu, 24 Apr 2025 10:05:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u7tS2-00Bxr2-TY for pgsql-announce@lists.postgresql.org; Thu, 24 Apr 2025 10:05:03 +0000 Content-Type: multipart/mixed; boundary="===============7605395662116525092==" MIME-Version: 1.0 Subject: PostgreSQL Anonymizer 2.1: Blurring Images To: PostgreSQL Announce From: Dalibo via PostgreSQL Announce Reply-To: damien.clochard@dalibo.com Date: Thu, 24 Apr 2025 10:04:22 +0000 Message-ID: <174548906222.676.18051903079414551309@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: c17b7c5a6d8e4277ef90252d29fbbcc3e11e804e20871023b4c004efd21a2ef1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7605395662116525092== Content-Type: multipart/alternative; boundary="===============1596354283318180677==" MIME-Version: 1.0 --===============1596354283318180677== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Eymoutiers, France, April 18, 2025 `PostgreSQL Anonymizer 2.1` is out and it brings new possibilities in the f= ield 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 Postgr= eSQL 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, in= cluding advanced techniques such as: Substitution, Randomization, Faking, Pseudonym= ization, 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 : Aliba= ba Cloud, Crunchy Bridge, Google Cloud SQL, Microsoft Azure Database, Neon, Tembo See the [INSTALL] section of the documentation for more details ! [Masking Functions]: https://postgresql-anonymizer.readthedocs.io/en/latest= /masking_functions/ [Anonymous Dumps]: https://postgresql-anonymizer.readthedocs.io/en/latest/a= nonymous_dumps/ [Static Masking]: https://postgresql-anonymizer.readthedocs.io/en/latest/st= atic_masking/ [Dynamic Masking]: https://postgresql-anonymizer.readthedocs.io/en/latest/d= ynamic_masking/ [Masking Views]: https://postgresql-anonymizer.readthedocs.io/en/stable/mas= king_views/ [Masking Data Wrappers]: https://postgresql-anonymizer.readthedocs.io/en/st= able/masking_data_wrappers/ [INSTALL]: https://postgresql-anonymizer.readthedocs.io/en/latest/INSTALL/ Image Blurring, Privacy Protection Beyond Text Data ---------------------------------------------------------------------------= ----- Sensitive information doesn't just hide in obvious places. While columns like name and zipcode are typical targets for masking, BYTEA = columns often contain overlooked personal data in profile photos, shipping vouchers, barcodes, QR codes, delivery notes, etc. Of course the most efficient way to clean this kind of personal data is to = simply delete it with SECURITY LABEL FOR anon ON COLUMN user.photo IS 'MASKED WITH VALUE NULL'; But our new Image Blurring capability preserves visual data for testing whi= le protecting privacy: SECURITY LABEL FOR anon ON COLUMN user.photo IS 'MASKED WITH FUNCTION anon.image_blur(photo,5.0)'; This feature works seamlessly across all our masking strategies : apply it on-the-fly with [Dynamic Masking] and [Anonymous Dumps], or permanently with [Static Masking]. For more details, check out the documentation: Acknowledgments ---------------------------------------------------------------------------= ----- The image blurring feature was developped by Pierre-Marie Petit. Kudos to h= im for this tremendous innovation! This release also includes code, bugfixes, documentation, code reviews and = ideas from Anthony Dumontois, Matthias van de Meent, and other [contributors]. And also special thanks to the [PGRX] team for their amazing work! [contributors]: https://gitlab.com/dalibo/postgresql_anonymizer/-/blob/mast= er/AUTHORS.md [PGRX]: https://github.com/pgcentralfoundation/pgrx Join our community to improve data privacy ! ---------------------------------------------------------------------------= ----- PostgreSQL Anonymizer is part of the [Dalibo Labs] initiative. It is mainly developed by [Damien Clochard]. This is an open project, contributions are welcome. We need your feedback a= nd ideas! Let us know what you think of this tool, how it fits your needs and what features are missing. If you want to help, you can find a list of `Junior Jobs` here: --===============1596354283318180677== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable PostgreSQL Anonymizer 2.1: Blurring Images
 

PostgreSQL Anonymizer 2.1: Blurring Images

Eymoutiers, France, April 18, 2025

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

Enhanced Privacy Protection for= Your Data

PostgreSQL Anonymizer is an ex= tension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a Postgr= eSQL database.

The extension offers five different masking= strategies:

Each strategy is complemented by an enhance= d suite of Masking Functions, including advanced techniques such as: Substitution, Randomization, Faking, Pseudonym= ization, 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 : Aliba= ba Cloud, Crunchy Bridge, Google Cloud SQL, Microsoft Azure Database, Neon, Tembo

See the INSTALL section of the documentation for more detail= s !

Image Blurring, Privacy Protect= ion Beyond Text Data

Sensitive information doesn't just hide in = obvious places.

While columns like name and zipcode are typ= ical targets for masking, BYTEA columns often contain overlooked personal data in profile photos, shipping vouchers, barcodes, QR codes, delivery notes, etc.

Of course the most efficient way to clean t= his kind of personal data is to simply delete it with

SECURITY LABEL FOR anon ON COLUMN user.photo
IS 'MASKED WITH VALUE NULL';

But our new Image Blurring capability prese= rves visual data for testing while protecting privacy:

SECURITY LABEL FOR anon ON COLUMN user.photo
IS 'MASKED WITH FUNCTION anon.image_blur(photo,5.0)';

This feature works seamlessly across all ou= r masking strategies : apply it on-the-fly with Dynamic Masking and Anonymous Dumps, or permanently with Static Masking= .

For more details, check out the documentati= on:

https://postgresql-anonymizer.readthedoc= s.io/en/latest/masking_functions/#image-bluring

Acknowledgments

The image blurring feature was developped b= y Pierre-Marie Petit. Kudos to him for this tremendous innovation!

This release also includes code, bugfixes, = documentation, code reviews and ideas from Anthony Dumontois, Matthias van de Meent, and other contributors.

And also special thanks to the PGRX team for their amazing work!

Join our community to improve d= ata privacy !

PostgreSQL Anonymizer is part of the [Dalib= o Labs] initiative. It is mainly developed by [Damien Clochard].

This is an open project, contributions are = welcome. We need your feedback and ideas! Let us know what you think of this tool, how it fits your needs and what features are missing.

If you want to help, you can find a list of= Junior Jobs here:

https://gitlab.com/dalibo/postgresql_anony= mizer/issues?label_name%5B%5D=3DJunior+Jobs
This email was sent to you from Dalibo. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Dalibo.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============1596354283318180677==-- --===============7605395662116525092==--