Skip to content

Compare various solutions to deploy PostgreSQL in Kubernetes

There are multiple ways to deploy and manage PostgreSQL in Kubernetes. Here we will focus on comparing the following open source solutions:

Generic

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Open-source license Apache 2.0 AGPL 3 Apache 2.0, but images are under Developer Program Apache 2.0 MIT
PostgreSQL versions 12 - 16 14 - 16 13 - 16 12 - 16 11 - 15
Kubernetes conformance Various versions are tested Various versions are tested Various versions are tested Various versions are tested AWS EKS

Maintenance

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Operator upgrade ✅ ✅ ✅ ✅ ✅
Database upgrade Automated and safe Automated and safe Manual Manual Manual
Compute scaling Horizontal and vertical Horizontal and vertical Horizontal and vertical Horizontal and vertical Horizontal and vertical
Storage scaling Manual Manual Manual Manual Manual, automated for AWS EBS

PostgreSQL topologies

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Warm standby ✅ ✅ ✅ ✅ ✅
Hot standby ✅ ✅ ✅ ✅ ✅
Connection pooling ✅ ✅ ✅ ✅ ✅
Delayed replica 🚫 🚫 🚫 🚫 🚫

Backups

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Scheduled backups ✅ ✅ ✅ ✅ ✅
WAL archiving ✅ ✅ ✅ ✅ ✅
PITR ✅ ✅ ✅ ✅ ✅
GCS ✅ ✅ ✅ ✅ ✅
S3 ✅ ✅ ✅ ✅ ✅
Azure ✅ ✅ ✅ ✅ ✅

Monitoring

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Solution Percona Monitoring and Management and sidecars Exposing metrics in Prometheus format Prometheus stack and pgMonitor Exposing metrics in Prometheus format Sidecars

Miscellaneous

Feature/Product Percona Operator for PostgreSQL Stackgres CrunchyData CloudNativePG (EDB) Zalando
Customize PostgreSQL configuration ✅ ✅ ✅ ✅ ✅
Sidecar containers for customization ✅ 🚫 ✅ 🚫 ✅
Helm ✅ ✅ ✅ ✅ ✅
Transport encryption ✅ ✅ ✅ ✅ ✅
Data-at-rest encryption Through storage class Through storage class Through storage class Through storage class Through storage class
Create users/roles ✅ ✅ ✅ ✅ limited

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services. Join K8S Squad to benefit from early access to features and “ask me anything” sessions with the Experts.

Community Forum Get a Percona Expert Join K8S Squad

Last update: 2024-04-17