title: Postgresql won't restore dump
body: <p>I've been trying to restore dump file dump-postgres-202010121008.sql but it won't be restored, I've tried the following restoration methods but it seems of no use:</p>
  <p><strong>Method1: using pgAdmin 4</strong></p>
  <p>I've tried the pg_restore method with the following inputs:</p>
  <p>Format: custom or tar</p>
  <p>File name: path to the file</p>
  <p>Number of jobs: empty</p>
  <p>Role name: postgres</p>
  <p>When i click restore, i get a <code>Failed(exit code: 1)</code> with the following error message:</p>
  <pre><code>pg_restore: error: input file does not appear to be a valid archive
  </code></pre>
  <p>I've also tried Query Tool &gt; open file, still i got an error <code>File type not supported</code>.</p>
  <p><strong>Method 2: using command line</strong></p>
  <p>I've tried pg_restore command on terminal but it returned <code>pg_restore: error: input file does not appear to be a valid archive</code></p>
  <p>I've also tried the following commands:</p>
  <pre><code>su postgres
  psql postgres
  \i dump-postgres-202010121008.sql
  </code></pre>
  <p>However i got this log:</p>
  <pre><code>psql:dump-postgres-202010121008:42473: error: invalid command \��0�8�ӛӣ��X�H6����.�y�:���e�ne��Pc�9x@%&quot;˔U�rV7M=�
  psql:dump-postgres-202010121008.sql:42474: error: invalid command \�T����kW:����Һ�-kL
  psql:dump-postgres-202010121008.sql:42484: error: invalid command \M�Ǉ,�ϐ}�c,J�-�)ATo▒�HJ��+w
  psql:dump-postgres-202010121008.sql:783003: ERROR:  invalid byte sequence for encoding &quot;UTF8&quot;: 0xea 0xab 0x7a
  </code></pre>
  <p>Any help would be appreciated, thank you.</p>