tech_surveillance586 wordsRead on Arc Codex

PostgreSQL Anonymizer 3.2 : Faster Pseudonymization

Eymoutiers, France, Septembre 4th, 2026 Dalibo is pleased to announce PostgreSQL Anonymizer 3.2 introducing a new panel of fast pseudonymization filters. PostgreSQL Anonymizer is an extension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database. The extension offers 6 different masking strategies: 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. You can use it on most major DBaaS providers including : Alibaba 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! Although Pseudonymization is not Anonymization, it may be useful in some contexts. Until version 3.1, this was achieved with a panel of pseudo_* functions, such as anon.pseudo_last_name(...) , anon.pseudo_email(...) , etc. These functions are now replaced by a new panel of anon.seeded_* functions, such as anon.seeded_last_name(...) , anon.seeded_email(...) , etc. The anon.seeded_* functions have 2 main advantages over the previous ones: anon.seeded_street_name(id,'fr_FR') The anon.pseudo_* functions are kept for backward compatibility but are now deprecated and will be removed in a future version. We encourage all users to switch to the new anon.seeded_* functions as soon as possible. Version 3.2 includes fixes for 3 critical vulnerabilities allowing a user to gain superuser privileges under certain circumstances. The risk is very high on PostgreSQL 14 and on instances upgraded from PostgreSQL 14 and earlier. These vulnerabilities are declared below: All users should upgrade the extension to version 3.2 as soon as possible. See issue 665 and issue 666 for more details. Version 3.2 introduces a new security barrier that forbids superusers from using any kind of masking (static, dynamic, etc.). Enforcing the principle of "Least Privilege", the extension now refuses to run any masking function on behalf of a superuser. Especially if you are currently using static masking, replica masking or backup masking with a superuser, we advise you to create a dedicated role for that. The previous behaviour can be restored by setting anon.nosuperuser to FALSE , in which case the security barrier will be removed and superusers will be able to execute masking rules at their own risk. The JSON schema used for imports / exports has changed between version 3.1 and 3.2. It is recommended to re-export the rules after the upgrade to 3.2 See the UPGRADE section for more details. This release includes code, bugfixes, documentation, code reviews and ideas from Alain Lesage, Benoit Lobréau and other contributors. Kudos to Alain for his first contributions ! CVE-2026-19633 and CVE-2026-19634 were reported by Sarath Kumar, IITM Pravartak Security Team CVE-2026-83534 was reported by Alexander Kukushkin. Many thanks to them and to the PostgreSQL Security Team. We would also like to thanks the people at Efluid who helped us with their ideas, comments and testing. And also special thanks to the PGRX team for their amazing work! PostgreSQL Anonymizer is part of the [Dalibo Labs] initiative. It is mainly developed by [Damien Clochard] and [Benoit Lobréau]. 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.

How it works

Once you click Generate, Ollama reads this article and crafts 5 comprehension questions. Your answers are graded against the article content — general knowledge won't be enough. Score 70+ to count toward your certificate.

Questions are cached — you'll always get the same 5 for this article.