Closed hancush closed 2 years ago
Related to #206
HCG to research whether default Heroku Postgres add-on offers backups by default this cycle.
All Heroku Postgres databases are protected through continuous physical backups. These backups are stored in the same region as the database and retrieved through Heroku Postgres Rollbacks on Standard and Premium tier databases. However, Hobby tier databases do not offer rollbacks, forks or followers.
https://devcenter.heroku.com/articles/heroku-postgres-data-safety-and-continuous-protection
We don't generally use Standard plans for staging sites, but recommend at least the lowest tier Standard plan for production, which means our apps should be covered (although we should check).
Verified this on the MN Election Archive production app, which uses a Standard-0 database:
For Standard-0 Postgres databases, your data — and any changes made to the database — are continuously and automatically backed up over the last 4 days. This allows you to create a clone of your database and roll back to a specific point in time.
Info on recovering from data loss here: https://devcenter.heroku.com/articles/heroku-postgres-rollback
Create or migrate existing doc on database backups, then add info on Heroku and a placeholder for RDS.
Related to #217.
Background
Once we set a policy for database backups, we'll need a method to implement it for our qualifying apps on Heroku.
Proposal
Investigate whether additional configuration is needed to back up Heroku Postgres databases. If backups come out of the box, learn how they work and add pointers to relevant documentation for restoring from a backup.
Deliverables
This R&D should result in documentation on how to set up and work with database backups for our apps deployed on Heroku.
Timeline
1-2 days