Both pg_dump and pg_restore can be called from ruby. Try dumping the database to temp, compressing, and uploading to s3. Restoring is the same process in reverse.
On Mar 17, 11:00 am, Mike <mikel...@gmail.com> wrote: > I'm going to take the lack of response to indicate that it is not > possible to restore a bundle. > > In light of that, is it actually even feasible to run an application > on Heroku with a data backup policy? > > I've seen numerous accounts of people out there using cron scripts to > download bundles as a backup strategy, but while the bundles can help > you get a copy of your data, what good is that if there's no way to > use it? > > There's always db:push, but someone in my other thread indicated that > the time it requires nears infinity at only 500 MB of data. > > What is everyone out there doing for backups? > > On Mar 14, 8:25 pm, Mike <mikel...@gmail.com> wrote: > > > > > I've been struggling with how to get a large dataset onto my Heroku > > application (see my thread > > here:http://groups.google.com/group/heroku/browse_thread/thread/2ef6fd99a5...). > > An approach I had thought would be good would be generating a local > > bundle of some type and uploading it to Heroku where it could be > > reanimated, However, I'm not sure if this is possible. > > > This got me thinking about how if that is not possible, whether these > > bundles could be used for backup at all. They are the advertised > > preferred way of backing up a Heroku > > application:http://docs.heroku.com/backups > > > However, in the documentation, even while it is stated that for best > > backup procedures data should be backed up in the form of downloading > > the bundles, there is no mention of how to restore a bundle that has > > been downloaded. Under the documentation for Heroku's command-line > > tool, the only bundle commands listed are: bundles, bundles:capture, > > bundles:download, bundles:animate, and bundles:destroy. > > > How can I re-upload a bundle to an application and then set the > > application to overwrite its database with the bundle's information? > > Is it possible? > > > And if it is possible, is it possible for me to locally create a > > bundle in order to use this to upload a large multi-gig database to my > > application? -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
