Restore PostgreSQL backup within Heroku
·138 words·1 min
Recently I was playing around with my local database in my Rails project deployed using Heroku. Eventually, I screwed up and had to delete all the data.
rake db: reset and rake db:create`, but how would I populate the data again?
With three simple lines of code in your terminal, you can download your production database and load it in your local environment.
In your terminal and your project folder, type:
curl -o latest.dump `heroku pgbackups:url`
These two lines create a backup and save it to the file called
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U my user -d mydb latest.dump
With this last line, we are restoring the database from the backup file; remember to change
myuser for your current user and
mydb for your database name.
I hope this helps.