postgres-ha icon indicating copy to clipboard operation
postgres-ha copied to clipboard

Backups

Open davissp14 opened this issue 4 years ago • 2 comments

Right now, we are performing volume-based snapshots every 24 hours and sending them up to s3. This is a good start, but we have a few things that need to happen before this is useful for the end-user.

MVP

  • [x] Expose snapshots through flyctl https://fly.io/docs/getting-started/multi-region-databases/#listing-snapshots
  • [ ] Snapshots should be downloadable
  • [ ] Snapshots should be able to be made on-demand
  • [ ] Come up with a retention strategy.

davissp14 avatar Aug 10 '21 15:08 davissp14

Perhaps also help with rotation? ("keep ${daily,weekly,monthly} backups for ${180 days, 12 months}")

jbergstroem avatar Nov 10 '21 14:11 jbergstroem

Also,

  • [ ] Support restoring encrypted snapshots

tv42 avatar May 26 '22 22:05 tv42