5 ms·

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.