title: pg_restore: [archiver] input file appears to be a text format dump. Please use psql
body: <p>I was trying to create a new database (analyses_db) on a remote server from a sql file by the command:</p>
  <pre class="lang-none prettyprint-override"><code>pg_restore -d analyses_db byoryn_resource.sql
  </code></pre>
  <p>I received the error message</p>
  <blockquote>
  <p>pg_restore: [archiver] input file appears to be a text format dump. Please use psql.`</p>
  </blockquote>
  <p>When I tried to follow the instruction: <em>(from <a href="https://stackoverflow.com/a/40632316/15721796">https://stackoverflow.com/a/40632316/15721796</a>)</em></p>
  <blockquote>
  <p><strong>To reload such a script into a (freshly created) database named newdb:</strong><br />
  <code>$ psql -d newdb -f db.sql</code><br></p>
  </blockquote>
  <p>I received:</p>
  <pre class="lang-none prettyprint-override"><code>psql: could not connect to server: No such file or directory
          Is the server running locally and accepting
          connections on Unix domain socket &quot;/var/run/postgresql/.s.PGSQL.5432&quot;?
  </code></pre>
  <p>I have no idea how to solve this, as a rookie. The SQL file should be alright as it is provided.</p>