Offline database backups - Githubissues

acteng / update-your-capital-schemes

Update your capital schemes service.

https://update-your-capital-schemes.activetravelengland.gov.uk/

MIT License

4 stars 0 forks source link

Offline database backups #160

Closed markhobson closed 1 month ago

markhobson commented 2 months ago

We have automated database backups (#97) but also need cold or offline database backups too for disaster recovery.

markhobson commented 1 month ago

NCSC guidance: https://www.ncsc.gov.uk/blog-post/offline-backups-in-an-online-world

markhobson commented 1 month ago

Tasks

[x] Store database password as secret
[x] Compress dump
[x] Encrypt dump using passphrase in Bitwarden
[x] Timestamp dump
[x] Document backup script
[x] Test restoring locally
[x] Test restoring in GCP
[x] Backup prod database off GCP