title: A faster way to copy a postgresql database (or the best way)
body: <p>I did a pg_dump of a database and am now trying to install the resulting .sql file on to another server.</p>
  
  <p>I'm using the following command.</p>
  
  <pre><code>psql -f databasedump.sql
  </code></pre>
  
  <p>I initiated the database install earlier today and now 7 hours later the database is still being populated. I don't know if this his how long it is supposed to take, but I continue to monitor it, so far I've seen over 12 millon inserts and counting. I suspect there's a faster way to do this. </p>