Copy your production database to your staging database hosted on Heroku
1) backup production database: | |
heroku pgbackups:capture --expire --remote production | |
2) obtain url string to backup from step 1: | |
heroku pgbackups:url --app production_app_name --remote production_app_branch_name | |
3) transfer backup from production to staging app: | |
heroku pgbackups:restore DATABASE 'production_app_backup_url_string_from_step_2' --app production_app_name --app staging_app_branch_name |
This comment has been minimized.
This comment has been minimized.
in step 3, I think you meant staging_app_name instead of production_app_name |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
Also: https://gist.github.com/1095522 (from http://stackoverflow.com/questions/6930624/how-can-i-make-my-staging-and-production-have-the-same-data-heroku)