Hey Paul, sorry -- I'm super-busy right now but I'll at least tap out a bit of a reply.
On Tue, Nov 16, 2010 at 1:34 PM, Paul Dowman <[email protected]> wrote: > Hey Heroku guys, just bumping this thread. > > To summarize: do we need to do automated regular backups to protect > against Postgres or some other part of Heroku infrastructure going > down, or is the database guaranteed to be reliable? > > We take automated backups as disaster insurance, but make no promises about their intervals. In the event of an outage, we handle recovery. If there is the potential for data loss, we reach out to any affected users. > I'm guessing we do, and if so how do we do that since an hourly dump > of postgres via cron isn't reliable enough or scalable? (i.e. you can > lose up to an hour of data, and more as the dump starts to take longer > with a large dataset.) > Hourly dumps is probably your best solution at the moment, but we're aware that there are better solutions out there and would love to schedule those into our release schedule some time soon. Having said that, in the three years we've been running PostgreSQL, I believe the number of data-loss failures (and by that I mean restore-from-backup failures) could be counted on one hand. -pvh -- 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.
