3 ms·

"Forget daily backups, Continuous Protection redundantly archives data to high-durability storage as it is written, ensuring that it is safe no matter what." I

by jvehent 15y ago

"Forget daily backups, Continuous Protection redundantly archives data to high-durability storage as it is written, ensuring that it is safe no matter what." I'm sorry, but daily backups are not only for high availability, but also for point in time recovery. What if $dev drops the user table by mistake ? Do they provide backup for that ?

joevandyk 15y ago
You can make snapshots of the data.
olefoo 15y ago
You can set up Point In Time Recovery (PITR), and replay recovery logs. It's not clear from Heroku's pages whether their solution is set up that way.
- jpitz 15y ago
  It sounds like their solution is set up that way. From https://postgres.heroku.com/#protect https://postgres.heroku.com/#protect : "Every change to your data is written to write-ahead logs, which are shipped to multi-datacenter, high-durability storage. In the unlikely event of unrecoverable hardware failure, these logs can be automatically 'replayed' to recover the database to within seconds of its last known state."
  - moe 15y ago
    It sounds like their solution is set up that way. I think the question is whether the customer will be able to perform a point in time recovery, and what the size and resolution of the backlog is.
    - pvh 15y ago
      Not yet.
      - jpitz 15y ago
        Thank you for that clarification.
pvh 15y ago
We have found that large production databases do not appreciate having frequent full SQL dumps taken from them. We offer an automatic daily snapshot option because we believe that for a production database it's really not wise to take dumps more frequently than that, though there's nothing stopping you from rolling your own.