Skip to content
logo
Percona Operator for PostgreSQL
Design and architecture
Initializing search
    percona/k8spg-docs
    percona/k8spg-docs
    • Welcome
      • System Requirements
      • Design and architecture
      • Comparison with other solutions
      • Install with kubectl
      • Install on Google Kubernetes Engine (GKE)
      • Generic Kubernetes installation
      • Application and system users
      • Exposing the cluster
      • Anti-affinity and tolerations
      • Transport Encryption (TLS/SSL)
      • Telemetry
      • Backup and restore
      • High availability and scaling
      • Monitor with Percona Monitoring and Management (PMM)
      • Add sidecar containers
      • Restart or pause the cluster
      • Custom Resource options
      • Percona certified images
      • Release notes index
      • Percona Operator for PostgreSQL 2.1.0 Tech preview (2023-05-04)
      • Percona Operator for PostgreSQL 2.0.0 Tech preview (2022-12-30)
    • Join K8S Squad

    Design overview¶

    The Percona Operator for PostgreSQL automates and simplifies deploying and managing open source PostgreSQL clusters on Kubernetes. The Operator is based on CrunchyData’s PostgreSQL Operator.

    image

    PostgreSQL containers deployed with the Operator include the following components:

    • The PostgreSQL database management system, including:

      • PostgreSQL Additional Supplied Modules,

      • pgAudit PostgreSQL auditing extension,

      • PostgreSQL set_user Extension Module,

      • wal2json output plugin,

    • The pgBackRest Backup & Restore utility,

    • The pgBouncer connection pooler for PostgreSQL,

    • The PostgreSQL high-availability implementation based on the Patroni template,

    • the pg_stat_monitor PostgreSQL Query Performance Monitoring utility,

    • LLVM (for JIT compilation).

    To provide high availability the Operator involves node affinity to run PostgreSQL Cluster instances on separate worker nodes if possible. If some node fails, the Pod with it is automatically re-created on another node.

    image

    To provide data storage for stateful applications, Kubernetes uses Persistent Volumes. A PersistentVolumeClaim (PVC) is used to implement the automatic storage provisioning to pods. If a failure occurs, the Container Storage Interface (CSI) should be able to re-mount storage on a different node.

    The Operator functionality extends the Kubernetes API with Custom Resources Definitions. These CRDs provide extensions to the Kubernetes API, and, in the case of the Operator, allow you to perform actions such as creating a PostgreSQL Cluster, updating PostgreSQL Cluster resource allocations, adding additional utilities to a PostgreSQL cluster, e.g. pgBouncer for connection pooling and more.

    When a new Custom Resource is created or an existing one undergoes some changes or deletion, the Operator automatically creates/changes/deletes all needed Kubernetes objects with the appropriate settings to provide a proper Percona PostgreSQL Cluster operation.

    Following CRDs are created while the Operator installation:

    • perconapgclusters stores information required to manage a PostgreSQL cluster. This includes things like the cluster name, what storage and resource classes to use, which version of PostgreSQL to run, information about how to maintain a high-availability cluster, etc.

    • perconapgbackups and perconapgrestores are in charge for making backups and restore them.

    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.