Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
@jhjwind

This comment has been minimized.

Copy link

jhjwind commented Jan 8, 2014

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
You can’t perform that action at this time.