Editorial Q&A139.9K views2,978 votes2 answers2 comments845 following
A restored PostgreSQL database opens successfully; what should we validate before cutover?
An example team restores a database containing user accounts, posts and a reputation ledger. Basic SQL queries work. They are about to switch the application but have only compared table counts. What additional checks would make the recovery decision more meaningful?