Sample Header Ad - 728x90

postgres 11.3 checksum validation post migration

0 votes
2 answers
244 views
I am in the process of migrating our AWS RDS postgresql from one account to another with zero downtime. I am going with pg_dump/pg_restore + AWS CDC for ongoing replication. I am looking for a way to generate and compare checksum to make sure no differences in data or corruption. Q1: Is it possible to generate checksum on the database level rather than table level? Q2: OR doing a select count(*) on all the tables in source/target is better? when there is no downtime, data changes will be coming in the source during this process and i am afraid this will affect the checksum or rowcount comparison. Please advise
Asked by Falcon (101 rep)
Sep 15, 2022, 01:01 PM
Last activity: Jun 8, 2025, 09:10 AM