DB Backups

RDS Backups are useful in case of a DR but are hard to use if someone needs to investigate a bug or wants the data locally to investigate.

We automated creating nightly postgresql dumps using Kubernetes CronJobs and AWS S3 and them accessible through an internal UI from where you can download them using a S3 presigned-url.

TODOs:

• Cloudflare Access Headers/JWT validation
• IRSA

Further reading

• https://github.com/Fortech-Products-SRL/aiperion-psql-s3-backup
• https://github.com/Fortech-Products-SRL/RMT-DB-Dumpster