PostgreSQL on Kubernetes - Best Practices and Common Pitfalls

Learn essential best practices and common pitfalls for running PostgreSQL databases on Kubernetes in this 41-minute conference talk from Conf42 IoT 2024. Explore key topics including common misconceptions about databases in containerized environments, security considerations, backup strategies, and optimal configuration settings for PostgreSQL performance. Gain practical insights into managing persistent volumes, implementing the Container Storage Interface (CSI), setting up connection pooling, and leveraging Kubernetes operators. Discover why organizations choose to run PostgreSQL on Kubernetes and how to effectively handle database versioning, storage management, and extensions while avoiding typical deployment mistakes.

Syllabus

00:00 Introduction and Misunderstood Title
00:56 Speaker Background and Experience
03:06 Interactive Game: Family Thought
04:19 Common Misconceptions About Databases on Kubernetes
10:22 Why Run Postgres on Kubernetes?
13:55 Security and Backup Best Practices
17:51 Postgres Configuration on Kubernetes
19:48 Postgres Configuration for Performance
20:04 Understanding Postgres Extensions
21:23 Managing Postgres Versions and Storage
23:18 Kubernetes and Persistent Volumes
24:03 Container Storage Interface CSI in Kubernetes
30:09 Connection Pooling in Postgres
35:50 Kubernetes Operators for Postgres
39:14 Final Thoughts on Postgres and Kubernetes