title: Can't restore a dump backup file for Postgres using pg_restore
body: <p>I generated a dump backup file for my Postgres 9.3.4 using this: </p>
  
  <pre><code>pg_dump table_name -U myusername -h localhost -O &gt; backup.dump
  </code></pre>
  
  <p>Now I'm trying to backup the old database using: </p>
  
  <pre><code>pg_restore -U myusername -n public -d table_name  backup.dump
  </code></pre>
  
  <p>But I keep getting this error: </p>
  
  <pre><code>pg_restore: [archiver] input file appears to be a text format dump. Please use psql.
  </code></pre>
  
  <p>Please note that the file is not plain sql file since I generated it using pg_dump. </p>
  
  <p>I used the follwoing command: </p>
  
  <pre><code>psql perchwell -U myusername -f backup.dump -v ON_ERROR_STOP=1
  </code></pre>
  
  <p>and start receiving the following error: </p>
  
  <pre><code>SET
  SET
  SET
  SET
  SET
  SET
  psql:backup.dump:16: ERROR:  schema "propertydir" already exists
  </code></pre>