1

Is there any tools working with Azure Database for PostgreSQL doing Anonymization and/or doing Data Masking ?

Is there a better way that this workflow :

1- Copy production DB (from Azure Database for PostgreSQL) via pg_dump,

2- Create Docker image with postgresql,use pg_restore to restore DB, use postgresql-anonymizer (apply Data Masking Rules) and create anonymized dump.

The goal is to have a production database dump anonymized for DEV/QA.

Thanks for your help

FBARBIER
  • 11
  • 3
  • Can't you install postgresql-anonymizer in production? –  Mar 25 '20 at 16:00
  • No, I can't install posgresql extension in the Azure managed postgresql, and postgresql-anonymizer is not available (https://learn.microsoft.com/bs-cyrl-ba/azure/postgresql/concepts-extensions). – FBARBIER Mar 25 '20 at 16:35

1 Answers1

0

There are a number of tools out there that do exactly what you're looking for. My favorite is Tonic (full disclosure, I work there)

lauris
  • 1