cloudnative-pg/cloudnative-pg
Cloudnative Pg
CloudNativePG is a Kubernetes operator designed for the administration, lifecycle management, and high availability of PostgreSQL database clusters. It functions as a declarative orchestrator that manages database instances through custom resources and manifests.
The project distinguishes itself by automating complex operational tasks, including primary election and failover management via streaming physical replication. It provides specialized tools for database version migrations, supporting both offline in-place upgrades and online migrations through logical replication.
The operator covers a broad range of capabilities including continuous physical backups to object storage with point-in-time recovery, dynamic cluster scaling, and persistent storage orchestration. It also handles traffic management by routing read-write and read-only requests to different endpoints and provides observability through performance metrics export and cluster health monitoring.
Security is integrated through network traffic encryption and support for client certificate authentication.
Features
- Kubernetes Operators - Functions as a Kubernetes operator that manages the entire database lifecycle using custom resource definitions.
- Backup & Recovery - Provides physical backup and recovery capabilities using snapshots stored in cloud object storage.
- Database Orchestration - Manages the lifecycle, scaling, and recovery of PostgreSQL clusters through declarative Kubernetes manifests.
- Database Replication - Uses streaming and file-based physical replication to keep standby replicas synchronized with the primary node.
- PostgreSQL Administration Tools - Provides utilities for performing rolling updates, major version upgrades, and read-replica scaling.
- Cluster Lifecycle Management - Automates the provisioning and operational lifecycle of PostgreSQL database clusters.
- PostgreSQL Kubernetes Administration - Provides a native Kubernetes orchestration layer for the complete administration of PostgreSQL database clusters.
- Primary-Replica Replication - Utilizes streaming physical replication to synchronize data from the primary node to standby replicas.
- Point-in-Time Recovery - Enables restoring database clusters to a specific timestamp via continuous backups to object stores.
- Database Lifecycle Management - Automates the full operational lifecycle of database clusters, including deployment, scaling, and failover.
- Database High Availability - Ensures continuous service availability through automated failover and primary election in database clusters.
- Declarative Configuration Models - Uses a declarative configuration model to define and reconcile the desired state of database clusters.
- Automated Master Failovers - Implements automated primary election and reconfiguration to ensure high availability during node failures.
- Declarative Configuration - Manages database users, roles, and system settings through structured declarative manifests.
- Encrypted Connections - Implements encrypted database connections using SSL/TLS and integration with external certificate managers.
- Database Version Migrations - Executes major database version upgrades using either offline in-place updates or online migrations via logical replication.
- Scaling Orchestrators - Automatically scales the number of standby replicas by provisioning necessary storage and replication settings.
- Traffic Routing - Routes read-write and read-only traffic to different endpoints based on the database node role.
- Cluster Scaling Orchestrators - Dynamically adjusts the number of database instances to scale capacity based on workload requirements.
- Storage Volume Orchestration - Orchestrates persistent storage volume claims to ensure data persistence during pod migrations or updates.
- Distributed Database Deployment - Enables the deployment of replica clusters across multiple environments for hybrid or multi-cloud distribution.
- Rolling Update Orchestrators - Orchestrates rolling updates of database images by updating replicas first and performing a controlled switchover.
- Version Upgrades - Supports both offline in-place major upgrades and online migrations using logical replication.
- Network Encryption - Encrypts in-transit network traffic using certificates and supports both auto-generated and external credentials.
- Cluster Health Monitoring - Exposes database and operator health metrics for integration with external observability tools.
- Database Performance Monitoring - Exports PostgreSQL performance metrics and telemetry for integration with external observability tools.
- Metrics Exporters - Collects database telemetry via a built-in exporter for integration into monitoring pipelines.
- Service Alerting Configurations - Defines alert conditions and monitoring rules to notify administrators when performance thresholds are crossed.
- Kubernetes Operators - Comprehensive platform for managing PostgreSQL in Kubernetes.
