Skip to content

Instantly share code, notes, and snippets.

@tonycoco

tonycoco/heroku-pg-backup.sh

Last active August 29, 2015 13:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tonycoco/9011626 to your computer and use it in GitHub Desktop.
Save tonycoco/9011626 to your computer and use it in GitHub Desktop.
Download ZIP
Heroku PG Backup
Raw
heroku-pg-backup.sh
curl -o latest.dump `heroku pgbackups:url`
rake db:drop db:create db:migrate
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U root -d DATABASE_development latest.dump
rm latest.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment