CrunchyData/postgres-operator

Features

• Cluster State Reconciliation - Uses a continuous control loop to synchronize the actual state of database clusters with the desired state defined in custom resources.
• Database High Availability - Orchestrates high availability for PostgreSQL via automated failover, replica synchronization, and distributed consensus.
• Scheduled Database Backups - Executes database backups at defined intervals and applies retention policies to automate data cleanup.
• Backup and Recovery - Automates scheduled full and incremental backups to cloud storage with point-in-time recovery capabilities.
• Standby Management - Manages the promotion of read-only standby instances to primary status to enable write operations.
• Database Backup and Restore - Implements comprehensive systems for creating and restoring data backups and cloning existing clusters.
• Database Connection Poolers - Provides a proxy layer to manage and reuse database connections, optimizing resource utilization for high-traffic apps.
• Database Connectivity Management - Enforces TLS for all database traffic through integrated public key infrastructure management.
• Pod Anti-Affinity Constraints - Cloud-Native Backup Archiving uses affinity and topology constraints to prevent multiple database pods from landing on the same host.
• Connection Pool Managers - Implements a connection pooling layer to manage active sessions and prevent database server overload.
• Cloud Storage Backups - Streams full and incremental backups and write-ahead logs to cloud object storage for disaster recovery and point-in-time restoration.
• Connection Pooling - Implements a proxy-based connection pooling layer to optimize session management and reduce database connection overhead.
• Graceful Primary Switchovers - Supports controlled migration of the primary database role to a specific replica within a high-availability cluster.
• Persistent Storage Volumes - Defines persistent volume claims and storage classes to manage physical disk space for the database.
• PostgreSQL Cluster Management Platforms - Provides a comprehensive platform for deploying, scaling, and operating production PostgreSQL clusters on Kubernetes.
• PostgreSQL Kubernetes Administration - Manages PostgreSQL resources, storage volumes, and network endpoints using declarative Kubernetes operator patterns.
• Asynchronous Replica Synchronizations - Synchronizes replicas and restores failed primaries using delta restores of write-ahead logs.
• Backup Management - Manages both scheduled and manual backups to ensure data durability and recoverability.
• Point-in-Time Recovery - Provides mechanisms for restoring database states to specific historical moments by replaying archived logs.
• Database Cluster Scaling - Adjusts the number of database instances in a cluster via custom resources to ensure high availability.
• Controller Installations - Installs the management controller into a Kubernetes cluster to enable declarative database orchestration.
• Database Failover Consensus - Uses a coordinated agreement mechanism to automatically elect a new primary instance during node failures for high availability.
• Rolling Update Orchestrators - Orchestrates sequential restarts of database nodes and controlled switchovers to apply updates without service interruption.
• Role-Based Access Control - Manages user access levels by setting or revoking role attributes and permissions.
• Database Permissions - Defines database users and assigns specific access permissions and role attributes.
• Secrets and Credential Management - Securely manages the generation, storage, and rotation of database user passwords and connection URIs.
• TLS Traffic Encryption - Secures server and replication connections by mounting custom certificates and keys for TLS encryption.
• Object Storage Backups - Streams full and incremental backups and write-ahead logs to cloud object storage for point-in-time restoration.
• Multi-Mode Backup Execution - Performs full, differential, and incremental backups to either cloud object storage or local storage.
• Metrics Exporters - Deploys sidecar containers to export PostgreSQL engine metrics for integration with monitoring tools.
• Standby Cluster Cloning - Supports the creation of read-only standby clusters that synchronize state from an active cluster for disaster recovery.
• Backup-Based Cluster Migration - Creates new database clusters by restoring data from an existing backup repository.
• Backup Retention Policies - Expires old backup and log files based on a specified count or total number of days.
• Backup Repositories - Manages the distribution of backups across multiple storage locations to ensure geographic redundancy and recovery speed.
• Kubernetes Data Migrators - Moves existing database data into a managed Kubernetes cluster environment from external storage.
• Connection Pool Observability - Visualizes connection pool metrics and client states to help tune database performance.
• Disaster Recovery Workflows - Coordinates automated processes for off-site data persistence to cloud storage and recovery via standby clusters.
• Database Backup Restoration - Restores database state and metadata from backup snapshots to initialize new clusters or recover existing ones.
• Synchronous Replication Management - Ensures zero data loss by requiring transaction confirmation from at least one standby server before committing.
• Pooler Parameter Configuration - Provides fine-grained customization and automatic reloading of connection pooler parameters at global, database, and user levels.
• Database Extensions - Integrates essential database extensions such as PostGIS, TimescaleDB, and pgAudit across various engine versions.
• Logical Replication Synchronization - Supports moving data between active database clusters using logical replication publications and subscriptions.
• Replication Mode Configurations - Configures synchronous or asynchronous replication to balance data durability against transaction performance.
• Pre-existing Volume Attachments - Attaches existing persistent volumes for data and backups to new clusters by mapping paths.
• Connection Pool Security - Encrypts traffic between applications and the connection pooler using managed TLS certificates.
• Deployment Rollbacks - Enables reverting cluster components to previous container image versions to restore a stable operational state.
• Volume Deletion Protections - Prevents automatic deletion of persistent storage when a database cluster is removed.
• Query Performance Monitors - Tracks execution counts and runtimes to identify inefficient or slow database queries.
• Read-Only Data Replication - Deploys read-only standby clusters that synchronize data from a primary server via streaming replication.
• WAL Volume Isolation - Separates the database data directory from the write-ahead log using distinct persistent volume claims.
• Database Engine Updates - Provides automated updates to the PostgreSQL engine binary with minimal service interruption.
• Database Initialization Scripts - Executes idempotent SQL scripts from configuration maps to bootstrap database objects during cluster creation.
• Cluster Configuration Synchronization - Propagates configuration changes across all cluster nodes and triggers restarts to ensure operational consistency.
• Vertical Compute Scaling - Adjusts CPU and memory allocations for database instances and backup jobs using rolling updates.
• Cluster Resource Customization - Provides the ability to adjust container resources, storage size, and database configurations with minimal disruption.
• Deployment Topology Management - Assigns clusters to specific nodes and manages pod affinity to optimize hardware placement.
• Pod Distribution Optimizations - Spreads database and backup pods across different hostnames and zones to maximize fault tolerance and data safety.
• Deployment Rolling Restarts - Triggers a phased restart of database pods to apply configuration changes detected in cluster metadata.
• Topology-Aware Distribution - Uses affinity and anti-affinity constraints to spread database instances across different hosts and availability zones.
• Component Version Upgrades - Updates the controller software to newer versions while synchronizing custom resource definitions.
• Managed Database Upgrades - Automates major and minor PostgreSQL version upgrades using strategies to minimize downtime.
• Database Connection Pooling - Implements a pooling layer between applications and the database to manage active sessions and reduce connection overhead.
• Online Volume Expansions - Increases the size of persistent volume claims for data directories and backup repositories while online.
• Encrypted Backups - Secures database backups using AES-256 encryption with credentials stored in secure secrets.
• Automatic Certificate Rotations - Automatically generates and replaces client certificates before they expire to prevent service interruptions.
• Connection Credential Management - Manages database connection credentials stored as secrets to ensure secure and stable network access for applications.
• Database Migration Switchovers - Moves data to different volumes by provisioning new instances and performing a controlled switchover.
• Database Service Endpoints - Maintains consistent network endpoints for cluster components to preserve connectivity during failover or restoration events.
• Database Performance Alerting - Triggers notifications for critical database conditions such as replication lag and disk exhaustion.
• Cluster Monitoring Dashboards - Provides graphical dashboards to visualize the health and availability of multiple database clusters.
• Resource Monitoring - Reports container-level CPU, memory, and network usage for all database pods.
• Backup Health Monitors - Monitors backup recency and log archive health to ensure the recovery window is maintained.
• Network Service Health Monitors - Monitors traffic volume, error rates, and latency for the services providing access to database clusters.
• Sidecar Metric Collectors - Deploys auxiliary containers alongside database instances to collect and expose engine-specific telemetry to monitoring systems.
• PostgreSQL Performance Monitoring - Ships a coordinated observation stack for tracking query performance, database metrics, and resource utilization.
• Observability Stacks - Deploys a complete observability stack including exporters and dashboards for database health and performance.
• Data Management - Declarative management for PostgreSQL clusters.
• Kubernetes Operators - Production-grade PostgreSQL management for Kubernetes.

Star history