KubeBlocks
BlogsKubeBlocks Cloud
Overview
Quickstart

Operations

Lifecycle Management
Vertical Scaling
Horizontal Scaling
Volume Expansion
Manage PostgreSQL Services
Minor Version Upgrade
Modify PostgreSQL Parameters
PostgreSQL Switchover
Decommission PostgreSQL Replica
Recovering PostgreSQL Replica

Backup And Restores

Create BackupRepo
Create Full Backup
Scheduled Backups
Scheduled Continuous Backup
Restore PostgreSQL Cluster
Restore with PITR

Custom Secret

Custom Password

TLS

PostgreSQL Cluster with TLS
PostgreSQL Cluster with Custom TLS

Monitoring

Observability for PostgreSQL Clusters

tpl

  1. Supported Extensions
  2. Key Features
    1. Lifecycle Management
    2. Backup and Restore
    3. Supported Versions

Overview of KubeBlocks PostgreSQL Addon

PostgreSQL is a powerful, open-source relational database management system known for its:

  • Scalability for handling large datasets
  • Robust security features
  • Extensive customization options
  • Support for diverse applications

The KubeBlocks PostgreSQL Addon enhances PostgreSQL with additional capabilities and extensions:

Supported Extensions

ExtensionDescription
pgvectorEnables vector operations for AI/ML applications and similarity searches

The KubeBlocks PostgreSQL Addon provides a complete solution for deploying and managing PostgreSQL clusters in Kubernetes environments. Key features include:

  • Flexible deployment topologies
  • Comprehensive lifecycle management
  • Reliable backup and restore operations
  • Support for multiple PostgreSQL versions

Key Features

Lifecycle Management

KubeBlocks simplifies PostgreSQL operations with comprehensive lifecycle management:

FeatureDescription
Horizontal ScalingScale replicas in/out to adjust capacity
Vertical ScalingAdjust CPU/memory resources for PostgreSQL instances
Volume ExpansionDynamically increase storage capacity without downtime
Restart OperationsControlled cluster restarts with minimal disruption
Start/StopTemporarily suspend/resume cluster operations
Password ManagementAbility to set and manage custom root password for the PostgreSQL cluster during creation
Dynamic ConfigurationModify PostgreSQL parameters without restarting
Custom ServicesExpose specialized database endpoints
SwitchoverPlanned primary-replica role changes
Replica ManagementSafely decommission or rebuild specific replicas
Version UpgradesPerform minor version upgrades seamlessly
Advanced SchedulingCustomize pod placement and resource allocation
TLS EncryptionEnable/disable transport layer security
MonitoringIntegrated Prometheus metrics collection
LoggingCentralized logs via Loki Stack

Backup and Restore

KubeBlocks supports multiple backup strategies for PostgreSQL:

Backup TypeMethodDescription
Full Backuppg_basebackupNative PostgreSQL utility for complete database snapshots
Full BackupWAL-GEfficient backup tool with compression and cloud storage support
Continuouspostgresql-pitrUploads PostgreSQL Write-Ahead Logging (WAL) files periodically to the backup repository, usually paired with pg-basebackup
ContinuousWAL-G ArchiveUploads PostgreSQL Write-Ahead Logging (WAL) files periodically to the backup repository, usually paired with wal-g

Supported Versions

KubeBlocks PostgreSQL Addon supports these PostgreSQL versions:

Major VersionSupported Minor Versions
PostgreSQL 1212.14.0, 12.14.1, 12.15.0
PostgreSQL 1414.7.2, 14.8.0
PostgreSQL 1515.7.0
PostgreSQL 1616.4.0

The list of supported versions can be found by following command:

kubectl get cmpv postgresql

© 2025 ApeCloud PTE. Ltd.