Backups - Githubissues

fly-apps / postgres-ha

Postgres + Stolon for HA clusters as Fly apps.

Apache License 2.0

318 stars 131 forks source link

Backups #19

Open davissp14 opened 3 years ago

davissp14 commented 3 years ago

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.

jbergstroem commented 2 years ago

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

tv42 commented 2 years ago

Also,

[ ] Support restoring encrypted snapshots