Is there a way to copy RDS table without sensitive information?

Is there a special feature or service that can be used to copy RDS postgresql table from a DB to another without sensitive data like(emails, passwords, phone numbers....)

主題

資料庫

標籤

PostgreSQL 為 SQL Server 自訂的 RDS

語言

English

Robert Deschamps

已提問 1 年前檢視次數 1024 次

2 個答案

最新
最多得票
最多評論

已接受的答案

A dynamic data masking solution can be used in this case. You could leverage AWS DMS here is a link for more information: https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/ I would suggest that you use PostgreSQL Anonymizer but unfortunately it is not supported by RDS anymore.

Othnajid

已回答 1 年前

專家

Oleksii Bebych

已審閱 4 天前

專家

kentrad

已審閱 1 年前

kentrad 專家
1 年前
https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/

Hi, I would suggest to go one step further if you don't know where all your sensitive info is located: dump your db to S3 and run its content through MaCie Check out https://aws.amazon.com/macie/

專家

Didier_Durand

已回答 1 年前

Is there a way to copy RDS table without sensitive information?

相關內容