KubeBlocks for
PostgreSQL
PostgreSQL is a powerful, open-source object-relational database known for its robustness, extensibility, and standards compliance. It excels at complex queries, JSON support, full-text search, and geospatial data — making it a top choice for modern applications.
Supported versions
Available on
AWS
Azure
GCP
OCI
Alibaba Cloud
Rancher
OpenShiftDatabases
MySQL
PostgreSQLOracle
SQL Server
Redis
MongoDB
ClickHouseVector & AI
Qdrant
Milvus
ElasticsearchMessage queues
RocketMQ
RabbitMQ
KafkaOthers
VictoriaMetrics
InfluxDB
etcdExtend database engines like plug-ins
KubeBlocks provides unified database operations through its addon-based architecture. With KubeBlocks Enterprise, access over 15 seamless integrations to scale your database services.
One control plane, consistent operations across all engines — powered by the addon mechanism.
Run PostgreSQL with built-in operations, visibility, and recovery
From provisioning and scaling to access control, SQL management, observability, and backup recovery, the PostgreSQL addon helps teams operate production-ready databases from one console.
Lifecycle
Provision, restart, and retire PostgreSQL clusters with context
Launch PostgreSQL clusters faster, keep service changes visible, and handle routine lifecycle operations without switching between multiple tools.
- Create PostgreSQL 12, 14, 15, 16, or 17 clusters with guided topology, version, and sizing choices.
- Run restart workflows from the cluster context and keep task progress visible while nodes roll.
- Track cluster status, topology, and running tasks from the same operational view.
Cluster creation leads directly into a PostgreSQL overview with topology, version, sizing, and lifecycle controls.
Restart remains visible in cluster context so users can track rolling progress without leaving the detail page.
Scale
Scale resources, replicas, and storage by operational need
Adapt PostgreSQL capacity to growing workloads by expanding compute, replicas, and storage with clear change visibility.
- Use vertical scaling to adjust CPU and memory for changing workload pressure.
- Use horizontal scaling to expand replica capacity and HA footprint when topology allows.
- Expand storage online as database size grows while keeping the running service in view.
Horizontal scaling makes replica-count changes visible on the topology view instead of hiding them behind infrastructure details.
Volume expansion keeps storage growth inside the same operational workflow used for the running cluster.
SwitchOver
Perform planned role changes with the topology still in view
Handle planned primary-standby role changes with confidence and verify service topology immediately after the switch completes.
- Choose the target node from a PostgreSQL topology-aware workflow.
- Confirm which instance becomes primary right after the switch completes.
- Reduce operational risk by validating the new primary and standby layout at a glance.
SwitchOver keeps the post-change primary and standby layout visible on the same cluster view.
Parameter
Tune PostgreSQL parameters with controlled configuration changes
Tune PostgreSQL behavior with controlled parameter changes, clear value comparisons, and visible execution progress.
- Edit PostgreSQL parameters from a configuration-focused page.
- Review old and new values before the reconfiguration task is applied.
- Apply runtime tuning without dropping into manual configuration files or external tooling.
Parameter changes show the edited values and execution progress in one place.
Accessibility
Control database reachability with explicit access rules
Protect PostgreSQL access with explicit network rules, endpoint visibility, and connection controls that are easy to review.
- Manage access rules and CIDR-based allowlists from the access control page.
- Review endpoint and rule status in the same PostgreSQL workspace.
- Reduce exposure by allowing only approved client networks to connect.
Access rules make it easy to control which clients can connect to PostgreSQL.
Data Management
Create databases, manage users, and validate SQL
Give application teams the essentials they need to start using PostgreSQL: databases, users, and a built-in SQL workbench.
- Create databases or schemas for isolated workloads from the database management view.
- Create users with the right privileges for application access and administration.
- Use Query Workbench to run SQL and verify real read-write behavior from the console.
User creation and privilege assignment are available directly from the PostgreSQL management console.
Query Workbench lets users validate schema and query behavior without leaving the PostgreSQL console flow.
Observability
Inspect PostgreSQL health through metrics and logs
Monitor PostgreSQL health, performance, and runtime behavior with built-in metrics dashboards and log access.
- Monitor instance health, resource usage, and SQL-related insight from the metrics view.
- Inspect runtime logs from the logs page when diagnosing service behavior.
- Troubleshoot service issues faster with metrics and logs available in the same console.
Metrics dashboards surface PostgreSQL runtime health, resource usage, and SQL insight in one view.
Logs stay available from the same PostgreSQL workspace so troubleshooting does not require external tooling.
Audit
Track SQL activity and operational history
Keep a clear record of SQL activity and operational changes for troubleshooting, accountability, and review.
- Review executed statements and related metadata from SQL Audit.
- Track restart, scaling, restore, and reconfiguration history from the task list.
- Understand what changed, when it changed, and which operation produced the result.
SQL Audit keeps statement history visible for review and accountability.
Task history shows the execution trail for restart, scaling, backup, and recovery actions.
Backup
Protect and recover PostgreSQL data with backup workflows
Protect production data with built-in backup visibility and recover confidently when testing, migration, or incident response is required.
- Review backup strategy, repository, and completed jobs from the backups page.
- Trigger or inspect full backup execution without leaving the PostgreSQL workspace.
- Restore into a target cluster through a guided recovery path when validation or recovery is needed.
Backup views combine protection policy, repository details, and backup job status in one place.
Restore guides users through backup selection and recovery target settings step by step.
Ready to build your own DBaaS on Kubernetes?
Talk to our team and see how KubeBlocks Enterprise can help you consolidate databases, strengthen security, and reduce operational costs.