Amazon Aurora PostgreSQL introduces dynamic data masking
News
This article announces dynamic data masking support for Amazon Aurora PostgreSQL through the new pg_columnmask extension, enhancing database security for sensitive data protection.
- pg_columnmask enables column-level data masking based on user roles at query time
- Supports complete data hiding, partial value replacement, or custom masking approaches
- Multiple masking policies can be applied to single columns with precedence control
- Complements PostgreSQL's native row-level security and column-level grants
- Data masked at database level; stored data remains unmodified
- Helps comply with GDPR, HIPAA, and PCI DSS regulations
- Available for Aurora PostgreSQL 16.10+ and 17.6+ in all AWS regions
Aurora PostgreSQL now offers flexible, SQL-based dynamic data masking to simplify sensitive data protection across complex database queries.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Nov 24
2025
2025
Protect sensitive data with dynamic data masking for Amazon Aurora PostgreSQL
Dec 30
2024
2024
Dynamic data masking in Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, and Babelfish for Aurora PostgreSQL
Sep 18
2025
2025
Dynamic view-based data masking in Amazon RDS and Amazon Aurora MySQL
Jun 11
2026
2026
Amazon Aurora now supports PostgreSQL major version 18
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.