Anonymization and Dynamic Masking with PostgreSQL
summary
Shows how PostgreSQL can perform data anonymization inside the database using a PostgreSQL extension plus pure SQL rules to create masked roles, exports or permanent substitutions. Demonstrates three activation modes (dynamic masking at query time and one‑off substitution) and eight concrete techniques including destruction, adding noise, and shuffling, and explains when each preserves utility for statistics or development; it also notes that encryption is not anonymization and discusses installation via RPM and minimizing data movement per GDPR (articles 30/32).
AI-written summary · about
chapters (7)
- 0:00PostgreSQL anonymization intro
- 2:27GDPR key principles
- 8:45Anonymization complexity
- 14:02Reducing reidentification risks
- 17:42Dynamic masking with pg_anonymizer
- 22:36Anonymization techniques
- 29:41Conclusion
related talks
04mData Masking in PG
34mDatabase Anonymization with PostgreSQL
29mFinally Respecting GDPR Article 25 with PostgreSQL Anonymizer
32mAnonymizing Data in Postgres Without Losing Your Mind (or Your
28mOpen the gate a little: strategies to protect and share data
12mStriking the Balance: Safeguarding Customer Privacy While Empowering Employees
28mDon't leak user data to AI - Strategies for protecting PII from LLMs and MCP
26mDefining a Data Masking Framework at Scale