Heroku pg:backups:restore from local database

user_8598138 0
Viewed 3880

Heroku cannot access my google drive file but it is publicly accessible: https://drive.google.com/uc?export=download&id=0B4cYno3qd3jwSnN5V0JtOVZBb1k

Heroku errors:
1, please check the source URL and ensure it is publicly accessible
2, 'id' is not recognized as an internal or external command, operable program or batch file.

My code:
heroku pg:backups:restore "https://drive.google.com/uc?export=download&id=0B4cYno3qd3jwSnN5V0JtOVZBb1k" DATABASE_URL --app express-tourism

You can take a look at cmd line screenshot here

heroku
6 Answers

Got the same issue while using Google drive and then Dropbox. I resolved this by using Dropbox and changing url's 'https' to 'http'.

As per Heroku's docs:

In order for PG Backups to access and import your dump file you will need to upload it somewhere with an HTTP-accessible URL.

Keep in mind the URL should be a downloadable link as in the mentioned question. Hope this helps.

user_113874920
user_17428200

You can try saving backup in S3 and it should work as heroku itself is saving backups on AWS S3.

user_73025260

Dropbox works like a charm. Just make sure it's publicly accessible

user_63601080
Related