title: How to verify Postgres backup has been successful?
body: <p>What's the best way to verify that the backup and restore of a Postgres database has succeeded without issues?</p>
  
  <p>I am using the following to backup/restore:</p>
  
  <pre><code>sudo -u postgres pg_dump -Ft db &gt; database.tar
  sudo -u postgres pg_restore -Ft database.tar
  </code></pre>