nickjj_

For smaller databases (millions not billions of rows) getting an exact count on each table is what I usually do. I combine this with using built-ins provides by PostgreSQL like `\d+` to get a list of tables / relations. You can also count these tables if you have a ton of them. Beyond that, I'll spot check data before / after certain queries, it gives me a little more peace of mind that a `receipts` table has the same data it had after restoring. If the option is available, I'll do this in a staging environment first. This is especially helpful if you can run tests to assert you get the same application level results before and after the restore. Depending on how high the stakes are, it could be worth writing a whole bunch of these tests.