Database Anonymization with PostgreSQL

on YouTube ↗34m

" summary

Presentation explains strategies for anonymizing PostgreSQL databases to allow safe access to production-like data while minimizing leakage risk. It covers when to fully restrict access, when to allow it, and techniques to partially anonymize or mask data for legitimate use, aimed at developers and consultants working with Ruby web applications and PostgreSQL.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 3:34Data protection laws
3. 10:24Solution: data anonymization
4. 11:27PostgreSQL and pgAnon
5. 13:36Installing pgAnon
6. 14:17Static masking in pgAnon
7. 18:50Reordering and noise addition
8. 20:58Dynamic masking with pgAnon
9. 22:03Anonymized backups
10. 22:44Sensitive data generalization
11. 25:10Key lessons and recommendations
12. 26:55Q&A

" related talks

• 32mAnonymization and Dynamic Masking with PostgreSQLDamien Clochard · DevOps D-DAY 2019
• 29mFinally Respecting GDPR Article 25 with PostgreSQL AnonymizerNicolas GUILHEM · Devoxx France 2026
• 32mAnonymizing Data in Postgres Without Losing Your Mind (or YourAhmet Gedemenli, Esther Miñano Sanz · PostgreSQL Conference Europe 2025
• 28mOpen the gate a little: strategies to protect and share dataFernando Petrales · RailsConf 2022
• 04mData Masking in PGNishant Sharma · PGConf India 2025
• 07mAll about Postgres securityIbrar Ahmed · Percona University Istanbul 2022
• 40mPostgreSQL Security for Application DevelopersSehrope Sarkuni · PostgresOpen Silicon Valley 2017
• 50mPostgreSQL Security. How Do We Think?Masanori Oyama · FOSSASIA Summit 2017