Ryan Oboril ryanoboril
ryanoboril
/ import-db.sh
Created
June 6, 2018 20:49
— forked from hartleybrody/import-db.sh
Copy data from Heroku Postgres into local database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # copy/import data from heroku postgres to localhost pg database | |
| # useful for copying admin's work on live site into local database to reproduce errors | |
| # https://devcenter.heroku.com/articles/heroku-postgres-import-export | |
| # take heroku pg snapshot and download | |
| heroku pg:backups:capture | |
| heroku pg:backups:download | |
| # load the dump into local postgres database, assuming $DATABASE_URL set locally |