Command: heroku pg:backups capture -a [app_name]
Command: curl -o latest.dump `heroku pg:backups public-url -a [app_name]`
Command: pg_restore --verbose --clean --no-acl --no-owner -h localhost -d [db_name] latest.dump
-
-
Save guisehn/6648c8fdcd1102a22a22 to your computer and use it in GitHub Desktop.
Backup Heroku Postgres database and restore to local database
This was very helpful. Thanks for writing it. +1
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I changed my local and now I want to restore that file back into my heroku database