/plushcap/analysis/timescale/how-i-learned-to-love-postgresql-on-kubernetes-backup-restore-on-timescale

How I Learned to Love PostgreSQL on Kubernetes: Backup/Restore on Timescale

What's this blog post about?

The text discusses the importance of regular backups for relational databases like PostgreSQL to prevent data loss or enable data recovery. It explains how Timescale Cloud deploys PostgreSQL on Kubernetes and uses continuous archiving for backups, with a focus on TimescaleDB instances. The author shares their experience with backup and restore testing before implementing a more streamlined solution. They also discuss the use of Patroni for high availability in PostgreSQL and how they check for consistency and recentness during restore tests. The text emphasizes that backups are just one part of ensuring reliability, and Timescale's use of Kubernetes provides a decoupled compute and storage solution for more reliable fault tolerance.

Company
Timescale

Date published
June 28, 2024

Author(s)
Oleksii Kliukin

Word count
2128

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.