title: postgresql dump - unable to use it to create a new database on a new server
body: <p>I've run the following command on an existing database server: </p>
  
  <pre><code> pg_dump -C -U testuser testdb -h 127.0.0.1 -F t&gt; testdbdump
  </code></pre>
  
  <p>Now I'm trying to create this testdb on a new server. 
  I tried to run the following command on the new server: </p>
  
  <pre><code> pg_restore -h 127.0.0.1 testdbdump
  </code></pre>
  
  <p>I've created the testuser role on the new database server.  And then I also tried the following: </p>
  
  <pre><code>pg_restore -i -h 127.0.0.1 -p 5432 -U postgres "testdbdump"
  
  psql template1 postgres -f testdbdump
  </code></pre>
  
  <p>It did start to do some stuff, but I get a bunch of errors including: </p>
  
  <pre><code>psql:testdbdump:1720: invalid command \N
  psql:testdbdump:1721: invalid command \N
  psql:testdbdump:1808: ERROR:  syntax error at or near "user"
  LINE 1: user=phone
          ^
  </code></pre>
  
  <p>Did I create the dump file incorrectly?</p>