Dump/restore done. Now what?
Your pg_restore finished without errors. The data is there. The indexes are in place. Is it time to switch traffic? A successful restore can still leave you with painfully slow queries—and the first read can do more than just read. What is missing from the migration runbook?
Kirk Wolak and I explain why in Postgres.FM episode 193, “Dump/restore done. Now what?”[1] (transcript included).
Links
- [1] Postgres.FM episode 193, “Dump/restore done. Now what?” https://postgres.fm/episodes/dump-restore-done-now-what

