title: Importing a postgres database to Heroku using a pg_dump file
body: <p>I am using this guide from the Heroku documentation: <a href="https://devcenter.heroku.com/articles/heroku-postgres-import-export#import" rel="nofollow noreferrer">https://devcenter.heroku.com/articles/heroku-postgres-import-export#import</a></p>
  <p>It details how to import in a postgres to heroku so it can be used in a Heroku app.</p>
  <p>I am at the end and trying to use the command heroku
  <code>pg:backups:restore '&lt;SIGNED URL&gt;' DATABASE_URL</code></p>
  <p>What should be used as the DATABASE_URL?</p>
  <p>I have run heroku config and copied and pasted that DATABASE_URL, but I get the following error:
  <code>Unknown database: 'my plugged in url'. Valid options are: DATABASE_URL</code></p>