Database Backups & PostgreSQL 17 Upgrade

Automated Database Backups

Daily automated backups with cross-provider disaster recovery.

• Scheduled backups with local retention and offsite copy
• Cross-provider redundancy — backups stored on a separate cloud provider from the application server, in a UK region
• IAM scoped — backup credentials have minimum required permissions
• Restore verified — full dump-and-restore cycle tested against a separate database

PostgreSQL Upgrade

• Upgraded from PostgreSQL 15 to 17 with zero data loss
• PG 17 brings improved VACUUM, better JSON handling, and incremental backup support
• Old cluster removed, disk space reclaimed
• All data verified intact post-upgrade
• Fresh post-upgrade backup taken and uploaded offsite