PostgreSQL Anonymizer — an extension to the PostgreSQL DBMS that allows for the concealment or modification of confidential data or information that represents commercial secrets. Data masking occurs on the fly, using user lists for anonymization and configured rule templates.
The tool can be used to provide access to the database for third parties (e.g., analytics services), automatically stripping out personal data from queries, such as phone numbers or credit card information, or using more complex methods — replacing usernames, company names, and so on with fictitious information.
With the provided tool utility pg_dump_anon
, it is possible to create an anonymized database dump for transmission to third parties.
>>> Source Code (PostgreSQL license)
>>> Project page with installation instructions
Source: linux.org.ru
