title: Import postgres database without roles
body: <p>I have a database that was exported with pg_dump, but now when I'm trying to import it again with:</p>
  
  <pre><code>psql -d databasename &lt; mydump.sql
  </code></pre>
  
  <p>It fails trying to grant roles to people that don't exist. (error says 'Role "xxx" does not exist') </p>
  
  <p>Is there a way to import and set all the roles automatically to my user?</p>