CrunchyData/postgres-operator
4,423 stele·672 fork-uri·Go·Apache-2.0·2 vizualizăriaccess.crunchydata.com/documentation/postgres-operator/v5↗
Postgres Operator
Acest proiect este un operator Kubernetes conceput pentru deployment-ul și gestionarea clusterelor de baze de date PostgreSQL de producție folosind configurații declarative. Funcționează ca un controller care sincronizează starea reală a clusterelor de baze de date cu o stare dorită, oferind un sistem pentru orchestrarea disponibilității ridicate, backup și recuperare automată și administrarea bazelor de date containerizate.
Operatorul se distinge printr-o suită cuprinzătoare de protecție a datelor care suportă recuperarea la un moment dat (point-in-time recovery), backup-uri multi-mod către stocarea de obiecte în cloud și clonarea clusterelor. Asigură disponibilitatea continuă folosind consensul distribuit pentru failover automat și suportă gestionarea sofisticată a traficului printr-un connection pooler integrat.
Proiectul acoperă o gamă largă de capabilități operaționale, inclusiv replicarea sincronă și asincronă, colectarea de telemetrie printr-un stack de monitorizare dedicat și gestionarea securizată a identității cu rotația automată a certificatelor TLS. Oferă, de asemenea, instrumente pentru extinderea volumelor de stocare, actualizări ale motorului bazei de date și integrarea diverselor extensii de baze de date.
Controller-ul este instalat într-un cluster folosind manifeste customizabile pentru a permite orchestrarea declarativă a mediului bazei de date.
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.
- Gestionarea datelor - Declarative management for PostgreSQL clusters.
- Kubernetes Operators - Production-grade PostgreSQL management for Kubernetes.
