Run production PostgreSQL on Kubernetes the cloud-native way. Learn the operator model, HA and failover, backup and recovery, scaling, and day-2 operations.

Welcome to CloudNativePG: PostgreSQL on Kubernetes.

A practical, in-depth guide to CloudNativePG, the open-source Kubernetes operator for PostgreSQL. Learn how CloudNativePG runs production databases on Kubernetes: the database-on-Kubernetes problem (why stateful databases are hard), the operator model and the Cluster resource, the architecture (primary, replicas, streaming replication), high availability and automatic failover (avoiding split-brain and data loss), storage/backup/point-in-time recovery, replication/scaling/connection pooling with PgBouncer, day-2 operations (rolling updates, config, monitoring, scaling), security and best practices (TLS, RBAC, defense in depth), and CloudNativePG in practice.

This title is part of the ShriIra library and is free to read in full, right here — our small contribution to making world-class knowledge easy to reach.

A note on reading it: open the Contents menu at the top of the reader to jump between chapters, use the Aa menu to set a comfortable text size, theme (light, sepia, or night), and single- or two-page layout. Your place is saved automatically, so you can always pick up where you left off.

We hope it serves you well.

— Shriira Press

Contents

1. Chapter 1 — What CloudNativePG Is
2. Chapter 2 — The Database-on-Kubernetes Problem
3. Chapter 3 — The Operator Model and the Cluster Resource
4. Chapter 4 — Architecture: Primary, Replicas, and the Operator
5. Chapter 5 — High Availability and Failover
6. Chapter 6 — Storage, Backup, and Recovery
7. Chapter 7 — Replication, Scaling, and Connection Pooling
8. Chapter 8 — Day-2 Operations
9. Chapter 9 — Security and Best Practices
10. Chapter 10 — CloudNativePG in Practice