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.98.2) (envelope-from ) id 1xM2bZ-00000001pBu-1NHS for pgsql-announce@arkaria.postgresql.org; Wed, 28 Oct 2026 12:18:10 +0000 Received: from localhost ([127.0.0.1]:46180 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xM2bY-0000000GKMt-3T1h for pgsql-announce@arkaria.postgresql.org; Wed, 28 Oct 2026 12:18:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:39120) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM2bX-0000000GKMQ-3Jdr for pgsql-announce@lists.postgresql.org; Wed, 28 Oct 2026 12:18:08 +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.98.2) (envelope-from ) id 1xM2bV-00000001MHy-1sCT for pgsql-announce@lists.postgresql.org; Wed, 28 Oct 2026 12:18:06 +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=L8+yCdOMRtJgpGjtIhFItdDqu/CQpqTnG/QIj7AzaLI=; b=AxFlebIfHShqJcEeRbmrDRLDuR lCyq2bRSXbdsgSlIeu37iAzbKfR4KCQohl1kXvE66q3g/nxLesa+lRN22vH3w+nN7ezbGdx9hduml BfJsumrOT9Cf7l1x0tAYs4W7rRyZTBGHBpY6TPQ7Ya/sQpD3k9yF6byNQLKkLA5umuuXakI8OYQs8 Ex+D6O6dxrb3Nm6L1YBLx8AVj5P2rNzPTrGeUHNg+9UYENpK2PpSDvSrJ/N8M+2wzGpo6+2Mr5ciF Pjb12GcJVxJBP21zl5egp8Te5zmRiCmdIUzFzaEQ0j+mGvLjQMTENY15ifGZC7LfFS+3VALBT9f4+ CaSyZC+g==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM2bU-00000003v8m-48ke for pgsql-announce@lists.postgresql.org; Wed, 28 Oct 2026 12:18:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xM2bS-00000004GPH-1Rj0 for pgsql-announce@lists.postgresql.org; Wed, 28 Oct 2026 12:18:03 +0000 Content-Type: multipart/alternative; boundary="===============5385577268019415251==" MIME-Version: 1.0 Subject: PostgreSQL Anonymizer 3.3 : Major Security Update To: PostgreSQL Announce From: Dalibo via PostgreSQL Announce Reply-To: damien.clochard@dalibo.com Date: Wed, 28 Oct 2026 12:17:47 +0000 Message-ID: <179318986707.1247.2320267339914763890@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related,security X-pglister-tagsig: cd17e582844138b16b0b2ac3036ffa8fef977cac2b442d02edfbe72be65b0970 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5385577268019415251== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Eymoutiers, France, October 27th, 2026 Dalibo is pleased to announce `PostgreSQL Anonymizer 3.3` with a panel of important security fixes. 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 6 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, in= cluding advanced techniques such as: Substitution, Randomization, Faking, Pseudonym= ization, Partial Scrambling, Shuffling, Noise Addition and Generalization. The extension can be installed with Debian and RPM packages, an Ansible rol= e, a Docker image, etc. You can use it on most major DBaaS providers including : Alibab= a Cloud, Crunchy Bridge, Google Cloud SQL, IBM Cloud, Microsoft Azure Database, Neon= , Yandex It is also available on some Postgres forks such as EDB Advanced Postgres, = Greenplum and Yugabyte. See the [INSTALL] section of the documentation for more details! [Masking Functions]: https://postgresql-anonymizer.readthedocs.io/en/latest= /masking_functions/ [Backup Masking]: https://postgresql-anonymizer.readthedocs.io/en/latest/an= onymous_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/ [Replica Masking]: https://postgresql-anonymizer.readthedocs.io/en/latest/r= eplica_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/ Important Security Update ---------------------------------------------------------------------------= ----- Version 3.3 includes fixes for 12 critical vulnerabilities allowing some us= ers to gain superuser privileges under certain circumstances or allowing masked users to access personal information. These vulnerabilities are declared below: * [CVE-2026-110181]: Masked roles read the authentic data through SQL funct= ions with a SQL-standard body * [CVE-2026-105615]: Masked roles can read pg_stats * [CVE-2026-105616]: The secret salt is readable in pg_db_role_setting * [CVE-2026-110183]: After the static masking, pg_stats keeps the authentic values of the masked columns * [CVE-2026-105619]: Masking rules are not applied through security_invoker views * [CVE-2026-105618]: Dynamic masking does not work on inherited tables * [CVE-2026-110182]: anon.partial() and anon.partial_email() can leak data * [CVE-2026-105617]: Cached plans bypass transparent dynamic masking * [CVE-2026-105620]: Unauthorized access via subqueries * [CVE-2026-105612]: Data-modifying CTEs bypass the read-only restriction * [CVE-2026-105614]: Unbounded memory allocation (DoS) in image functions * [CVE-2026-105613]: DoS in range-based dummy functions [CVE-2026-110181]: https://www.cve.org/CVERecord?id=3DCVE-2026-110181 [CVE-2026-105615]: https://www.cve.org/CVERecord?id=3DCVE-2026-105615 [CVE-2026-105616]: https://www.cve.org/CVERecord?id=3DCVE-2026-105616 [CVE-2026-110183]: https://www.cve.org/CVERecord?id=3DCVE-2026-110183 [CVE-2026-105619]: https://www.cve.org/CVERecord?id=3DCVE-2026-105619 [CVE-2026-105618]: https://www.cve.org/CVERecord?id=3DCVE-2026-105618 [CVE-2026-110182]: https://www.cve.org/CVERecord?id=3DCVE-2026-110182 [CVE-2026-105617]: https://www.cve.org/CVERecord?id=3DCVE-2026-105617 [CVE-2026-105620]: https://www.cve.org/CVERecord?id=3DCVE-2026-105620 [CVE-2026-105612]: https://www.cve.org/CVERecord?id=3DCVE-2026-105612 [CVE-2026-105614]: https://www.cve.org/CVERecord?id=3DCVE-2026-105614 [CVE-2026-105613]: https://www.cve.org/CVERecord?id=3DCVE-2026-105613 **All users should upgrade the extension to version 3.3 as soon as possible= .** Upgrade ---------------------------------------------------------------------------= ----- Version 3.3 brings a series of new restrictions to prevent malicious behavi= ours. * Subqueries in masking rules are now forbidden * Inlining of functions is disabled for transparent dynamic masking * With dynamic masking, masked role are forbidden from executing function with SQL-standard bodies. This includes functions in contrib extensions that use this form (citext, earthdistance, etc. ) It is also strongly advised to change the value of the `anon.salt` GUC para= meter. See the [UPGRADE] section for more details. [UPGRADE]: https://postgresql-anonymizer.readthedocs.io/en/latest/UPGRADE Acknowledgments ---------------------------------------------------------------------------= ----- This release includes code, bugfixes, documentation, code reviews and ideas from Alain Lesage, @dmeremyanin, Gregoire Hubert and other [contributors]. Kudos to @dmeremyanin for his first contributions ! The security issues were reported by Alexander Kukushkin and Ilya Starovero= v. Many thanks to them for their efforts, their availability and the quality of their work. 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] and [Benoit Lobr=C3=A9au]. 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]. [Junior Jobs]: https://gitlab.com/dalibo/postgresql_anonymizer/issues?label= _name%5B%5D=3DJunior+Jobs --===============5385577268019415251== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable PostgreSQL Anonymizer 3.3 : Major Security Update
 

PostgreSQL Anonymizer 3.3 : Major Security Update

Eymoutiers, France, October 27th, 2026

Dalibo is pleased to announce Postgre= SQL Anonymizer 3.3 with a panel of important security fixes.

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 6 different masking st= rategies:

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 be installed with Debian = and RPM packages, an Ansible role, a Docker image, etc. You can use it on most major DBaaS providers including : Alibab= a Cloud, Crunchy Bridge, Google Cloud SQL, IBM Cloud, Microsoft Azure Database, Neon= , Yandex It is also available on some Postgres forks such as EDB Advanced Postgres, = Greenplum and Yugabyte.

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

Important Security Update

Version 3.3 includes fixes for 12 critical = vulnerabilities allowing some users to gain superuser privileges under certain circumstances or allowing masked users to access personal information.

These vulnerabilities are declared below:

All users should upgrade the extens= ion to version 3.3 as soon as possible.

Upgrade

Version 3.3 brings a series of new restrict= ions to prevent malicious behaviours.

  • Subqueries in m= asking rules are now forbidden
  • Inlining of fun= ctions is disabled for transparent dynamic masking
  • With dynamic ma= sking, masked role are forbidden from executing function with SQL-standard bodies. This includes functions in contrib extensions that use this form (citext, earthdistance, etc. )

It is also strongly advised to change the v= alue of the anon.salt GUC parameter.

See the UPGRADE section for more details.

Acknowledgments

This release includes code, bugfixes, docum= entation, code reviews and ideas from Alain Lesage, @dmeremyanin, Gregoire Hubert and other contributors.

Kudos to @dmeremyanin for his first contrib= utions !

The security issues were reported by Alexan= der Kukushkin and Ilya Staroverov. Many thanks to them for their efforts, their availability and the quality of their work.

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] and [Benoit Lobr=C3=A9au].

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=
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 for one of the content tags Related Open Source or Security. 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/.

 
--===============5385577268019415251==--