But let's say you have a modest sized database (modest relative to the total amounts allowable by Heroku) of 10GB. That way exceeds the 1GB soft limit on the temp directory, and there doesn't seem to be a straightforward way to get 10GB back into somewhere where you could call pg_restore on it is there?
On Mar 17, 12:32 pm, Michael <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 [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.
