CYBERTEC-PG-Operator
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage Support

The Project

The CYBERTEC PostgreSQL Operator (CPO) enables the simple provision and management of PostgreSQL clusters on Kubernetes. It reduces the administration effort and facilitates the management of single-node and HA clusters.

Main components

Features

  • Cluster management:
    • Single-node and HA (High Availability) clusters via Patroni
    • Reduction of downtime thanks to redundancy, pod anti-affinity, auto-failover and self-healing
    • Automated failover
    • Live volume resize without pod restarts
    • Basic credential and user management on K8s, eases application deployments
    • Compatible with OpenShift and Rancher
  • PostgreSQL compatibility:
    • Supports PostgreSQL versions 13 to 17
    • Inplace upgrades for smooth version changes and minimal downtime
    • Extensive extension support, including pgAudit, TimescaleDB and PostGIS
    • Standby-Cluster
  • Backup & Restore:
    • Integrated pgBackRest support
    • Automatic backups
    • Point-in-Time- and Snapshot-based Restores / Disaster Recovery
  • Connection management:
    • pgBouncer for connection pooling
  • Monitoring & alerting stack
    • Integrated metrics exporter
    • Prometheus, alert manager for metrics collection and alerting
    • Grafana for visual monitoring of the clusters
  • Operator UI:
    • Web interface for managing clusters

Installation

Detailed instructions on installation and configuration can be found in the CYBERTEC operator tutorials and in the following chapters Example of installation via Helm:

helm repo add cybertec https://cybertec-postgresql.github.io/helm-charts/
helm install pg-operator cybertec/cybertec-pg-operator

More information: Installation

Contribution

This project is open source, and contributions to its further development are expressly encouraged. Possible forms of contribution:

  • Bug reports and feature requests
  • Code contributions (pull requests welcome)
  • Improvement of the documentation Further details on contributions can be found in the respective GitHub repositories.

Licence

The CYBERTEC PostgreSQL Operator is licensed under the Apache 2.0 licence.