title: Can't import to heroku postgres database from dump
body: <p>Sorry if it is a duplicate, but I tried to find an answer here, and nothing helped.</p>
  
  <p>So I've read heroku articles like <a href="https://devcenter.heroku.com/articles/heroku-postgres-import-export">this</a> and <a href="https://devcenter.heroku.com/articles/heroku-postgres-backups">this</a>. I was able to save a dump file, which I've created with <code>pg:backups capture</code> command. Uploaded it to s3 and tried to restore it with:</p>
  
  <pre><code>heroku pg:backups restore DATABASE 'https://s3-eu-west-1.amazonaws.com/somebucket/uploads/tmp/b011.dump'
  </code></pre>
  
  <p>But it just do not work! In console it logs:</p>
  
  <pre><code>Unknown database: https://s3-eu-west-1.amazonaws.com/somebucket/uploads/tmp/b011.dump. Valid options are: DATABASE_URL, HEROKU_POSTGRESQL_SILVER_URL
  </code></pre>
  
  <p>Tried listed options instead of <code>DATABASE</code>, but with the same result. Also I've tried other hosting, but with the same result, again. I also tried to restore it from other app, like this:</p>
  
  <pre><code>heroku pg:backups restore myapp::b001 HEROKU_POSTGRESQL_SILVER --app myapp-cedar
  </code></pre>
  
  <p>But it logs with <code>Backup oncampus::b001 not found.</code> However, command <code>heroku pg:backups --app myapp</code> shows that it is present.</p>
  
  <pre><code>=== Backups
  ID    Backup Time                Status                              Size    Database
  ----  -------------------------  ----------------------------------  ------  --------
  b001  2015-03-13 18:10:14 +0000  Finished 2015-03-13 18:10:22 +0000  9.71MB  ORANGE
  </code></pre>
  
  <p>Don't know what to do now. Just hope someone will help me.</p>