Just wanted to let you guys/girls know that I've created a project up on github with backup and restore tasks using pg_dump. I've wanted this for a long time, and I figured some of you might too. I've seen a lot of backup solutions (which I've borrowed heavily from), but very few restores! I could just imagine scrambling to restore the database, having not tested it before.
Anyway, hope some people get some use out of this. http://github.com/jpearl/heroku_backups >From the readme: These rake tasks are basically a cleaned up and consolidated version of everything good I could find related to backup of heroku databases. It essentially takes advantage of pg_dump and pg_restore capailities of postgres. You can use it to run a nightly backup cron, or to transfer between environments. heroku rake db:backup --app from_application heroku rake db:restore -app to_application Notes: * You'll need to place your backup bucket name where it indicates in database.rake * You will need aws_s3 and yaml_db, since we're dumping both a database agnostic yaml file and a pg_dump compressed backup Things that could be done: * Most of you may not care about the yaml_db portion. I like it because I use mysql locally, even though I'm running on postgres at Heroku. You could easily rip this part out. Hope this helps some folks. -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
