title: Restoring database on Heroku from local dump using Cloud App
body: <p>I am trying to restore a database from my development environment to the production.</p>
  
  <p>I have followed the steps in 
  <a href="https://devcenter.heroku.com/articles/heroku-postgres-import-export">https://devcenter.heroku.com/articles/heroku-postgres-import-export</a></p>
  
  <p>I've created a dump locally and have uploaded it using CloudApp. Then I ran this command:</p>
  
  <pre><code>heroku pgbackups:restore HEROKU_POSTGRESQL_PURPLE_URL 'http://cl.ly/&lt;some_id&gt;/myapp.dump'
  </code></pre>
  
  <p>The error I'm getting is:</p>
  
  <pre><code>HEROKU_POSTGRESQL_PURPLE_URL (DATABASE_URL) &lt;---restore--- myapp.dump
  
  ! WARNING: Destructive Action
  ! This command will affect the app: myapp
  ! To proceed, type "myapp" or re-run this command with --confirm myapp
  
  &gt; myapp
  
  Retrieving... done
  
  ! An error occurred and your restore did not finish.
  </code></pre>
  
  <p>And if I take a look at the logs, it ends with this:</p>
  
  <pre><code>2012-12-02T17:30:42+00:00 app[pgbackups]: download_progress: start
  2012-12-02T17:30:42+00:00 app[pgbackups]: download_progress: 0B 
  2012-12-02T17:30:42+00:00 app[pgbackups]: 
  2012-12-02T17:30:42+00:00 app[pgbackups]: download_progress: 0.0bytes
  2012-12-02T17:30:42+00:00 app[pgbackups]: download_progress: done
  2012-12-02T17:30:42+00:00 app[pgbackups]: Invalid path
  </code></pre>
  
  <p>I have tested the url and it looks okay, I have searched for similar issues on the web, but found no answer.</p>
  
  <p>I have also tried to run <code>heroku update</code> but it was already up-to-date</p>
  
  <p>Am I doing something wrong, or is this a bug?</p>
  
  <p>I've also send a support ticket to them, but until they answer, I'd also like to hear if any of you stumbled upon something similar.</p>