title: How to restore postgresql database from .txt.gz file?
body: <p>Am using pgAdmin 4 and i want to restore my old database backup file which is in txt.gz format.</p>
  
  <p>I've tried using pgAdmin  to restore but getting error message like: </p>
  
  <blockquote>
    <p>pg_restore: [archiver] input file does not appear to be a valid archive</p>
  </blockquote>