Production to test with privacy, two separate databases, PostgreSQL

Share on facebook
Share on twitter
Share on linkedin

I have a large production database and need only partial, secured data for two databases

Source production database is large; 1TB that includes 100 tables and customer sensitive data.

To generate two databases for tests, we need only a small part of the production database: 4 tables with relevant data from the last 3 months, around 50G. Considering privacy regulations, we also need to mask sensitive data.

Test data total generation time is 10 minutes and is being executed twice into two different databases


Suggested reading