Skip to content
logo
Percona Operator for PostgreSQL
Comparison with other solutions
Initializing search
    percona/k8spg-docs
    percona/k8spg-docs
    • Welcome
      • System Requirements
      • Design and architecture
      • Comparison with other solutions
        • Generic
        • Maintenance
        • PostgreSQL topologies
        • Backups
        • Monitoring
        • Miscellaneous
      • Install on Minikube
      • Install with Helm
      • Install on Google Kubernetes Engine (GKE)
      • Generic Kubernetes installation
      • Install on OpenShift
      • Application and system users
      • Changing PostgreSQL Options
      • Anti-affinity and tolerations
      • Transport Encryption (TLS/SSL)
      • Telemetry
      • Backup and restore
      • Upgrade Percona Distribution for PostgreSQL and the Operator
      • Horizontal and vertical scaling
      • Monitor with Percona Monitoring and Management (PMM)
      • Restart or pause the cluster
      • Deploy a standby cluster for Disaster Recovery
      • Provide Percona Operator for PostgreSQL single-namespace and multi-namespace deployment
      • Use PostgreSQL tablespaces with Percona Operator for PostgreSQL
      • Creating a private S3-compatible cloud for backups
      • Custom Resource options
      • Operator installation options
      • Percona certified images
      • Frequently Asked Questions
      • Release notes index
      • Percona Operator for PostgreSQL 1.4.0 (2023-03-31)
      • Percona Operator for PostgreSQL 1.3.0 (2022-08-04)
      • Percona Operator for PostgreSQL 1.2.0 (2022-04-06)
      • Percona Operator for PostgreSQL 1.1.0 (2021-12-07)
      • Percona Operator for PostgreSQL 1.0.0 (2021-10-07)
      • Percona Operator for PostgreSQL 0.2.0 (2021-08-12)
      • Percona Operator for PostgreSQL 0.1.0 (2021-05-10)
    • Join K8S Squad

    • Generic
    • Maintenance
    • PostgreSQL topologies
    • Backups
    • Monitoring
    • Miscellaneous

    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:

    • Crunchy Data PostgreSQL Operator (PGO)
    • CloudNative PG from Enterprise DB
    • Stackgres from OnGres
    • Zalando Postgres Operator
    • Percona Operator for PostgreSQL

    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, 13, 14 14 12, 13, 14 11 - 14, 15 in Beta 11 - 14
    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 🚫 🚫 🚫 🚫 🚫
    Tablespaces ✅ 🚫 ✅ 🚫 🚫

    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 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 ✅ ✅ ✅ ✅ ✅
    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 ✅ ✅ ✅ limited

    Contact Us

    For free technical help, visit the Percona Community Forum.

    To get early access to new product features, invite-only ”ask me anything” sessions with Percona Kubernetes experts, and monthly swag raffles, join K8S Squad.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.

    Last update: 2023-05-22
    Percona LLC and/or its affiliates, © 2009 - 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.