Protecting your data with Patroni and pgBackRest
summary
Claims a working recipe to combine Patroni and pgBackRest so a cluster can bootstrap from pgBackRest repo and create replicas without a running primary. Shows etcd for DCS, Terraform for provisioning, Rocky Linux nodes and a GCP bucket for backups. Demonstrates backup to cloud (backup finishes in eight seconds, resulting backup set 3.2MB from a 25MB source) and a restore/bootstrap script that succeeds in recovering a new cluster and replicas.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 3:10PostgreSQL HA/DR challenges
- 4:19Use Patroni for PostgreSQL
- 7:54Backup strategies and testing
- 9:40Introducing pgBackRest
- 13:15Set up Patroni cluster with etcd
- 18:21Configure etcd and PostgreSQL
- 22:27Patroni configuration
- 26:02pgBackRest with GCP
- 30:02Disaster recovery
- 34:16Summary
- 35:33Q&A
related talks
41mEnsuring High Availability in Self-Managed PostgreSQL with Patroni
50mPatroni Deployment Patterns
49mPatroni: what the blog posts don't tell you...
51mHeavy Duty Backup w/PgBackRest
54mContainerized Clustered PostgreSQL
41mpgBackRest: Elevating PostgreSQL Backup Game
29mBuilding Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL
30mRunning PostgreSQL on Kubernetes in Production: Day 2 Operations with CloudNativePG