That looks pretty helpful. Have you tested it with any production datasets yet?
Carl On Mon, May 10, 2010 at 5:17 PM, Jason <[email protected]> wrote: > 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]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- 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.
