Recovering a database on Heroku from a local dump using the Cloud App

Question

I am trying to restore a database from my development environment for production.

I followed the steps at https://devcenter.heroku.com/articles/heroku-postgres-import-export

I dumped locally and downloaded it using CloudApp. Then I ran the following command:

heroku pgbackups:restore HEROKU_POSTGRESQL_PURPLE_URL 'http://cl.ly/<some_id>/myapp.dump' 

The error I get is:

 HEROKU_POSTGRESQL_PURPLE_URL (DATABASE_URL) <---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 > myapp Retrieving... done ! An error occurred and your restore did not finish. 

And if I look at the logs, this ends with the following:

 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 

I tested the url and it looks good, I searched for similar problems on the Internet but did not find the answer.

I also tried to launch heroku update , but it was already updated

Am I doing something wrong or is it a mistake?

I also sent them a support ticket, but until they answer, I would also like to hear if any of you have stumbled upon something like this.

Answer 1

I also could not get this to work with the cloud application, but I successfully used Dropbox.