Comment Comment by PaulMest I'd guess that https://neon.tech/ could help with this. Neon is branded as "Serverless Postgres". They have APIs to create branches of your database.So you could effectively:1) Create a snapshot of your production DB -> DB_2A2) Then create a snapshot of that snapshot -> DB_2B3) Now you have two copies of the exact same database. Run your query/workload/migration on DB_2B.4) Run some metadata queries against DB_2A and DB_2B and compare the results.5) If your metadata queries are inline with expectations, delete the snapshots. If not, leave them around for a bit for manual inspection. parent PaulMest 3 years ago
So you could effectively:
1) Create a snapshot of your production DB -> DB_2A
2) Then create a snapshot of that snapshot -> DB_2B
3) Now you have two copies of the exact same database. Run your query/workload/migration on DB_2B.
4) Run some metadata queries against DB_2A and DB_2B and compare the results.
5) If your metadata queries are inline with expectations, delete the snapshots. If not, leave them around for a bit for manual inspection.