title: How to verify that an archive produced by pg_dump archive is OK and valid?
body: <p>I am working on backup/restore data from postgresql for what I use <code>pg_dump.exe</code> and <code>pg_restore.exe</code>.  </p>
  
  <p>In order to restore backup file I have to delete actual tables in database what can be "suicidal job" if something with dumped file isn't OK.  </p>
  
  <p>I can check dumped file for integrity with (say) '7z t mydump.gz' what I do like first test.</p>
  
  <p>But I would like to know, because this archive is original PG archive did PostgreSQL contain any technique to check this '.gz' archive which I can take before deleting actual tables?  </p>
  
  <p>And if do, how to do a proper check?</p>
  
  <p>EDIT: This is my actual command for dumping:</p>
  
  <blockquote>
    <p>"C:\Program Files (x86)\PostgreSQL\9.1\bin\pg_dump.exe" --host localhost --port 5432 --username "postgres" --no-password --verbose -F t --file "C:\Users\User 1\Desktop\mydatabase.gz" "mydatabase"</p>
  </blockquote>