skills.rest
kettleofketchup
kettleofketchupCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

cloudnative-pg

Automate PostgreSQL cluster deployment and management on Kubernetes with CloudNativePG.

Updated Apr 3, 2026
Search Tags:#devops#postgresql#kubernetes#database-management#backup-recovery#cloudnative-pg#ha-cluster
One-click install
npx skills add https://github.com/kettleofketchup/KettleOfSkills --skill cloudnative-pg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloudnative-pg
Source: https://github.com/kettleofketchup/KettleOfSkills/tree/main/plugins/cloudnative-pg/skills/cloudnative-pg
Command: npx skills add https://github.com/kettleofketchup/KettleOfSkills --skill cloudnative-pg

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the complexity of manually provisioning, configuring, and maintaining PostgreSQL clusters on Kubernetes, reducing operational overhead and risk of misconfiguration for DevOps engineers and homelab users.

Core Features & Use Cases

  • Cluster Deployment: Supports both single-instance homelab setups and high-availability multi-replica production clusters with Rook Ceph storage integration.
  • Backup & Disaster Recovery: Provides guided setup for S3/MinIO backups via Barman Cloud Plugin, WAL archiving, scheduled backups, and point-in-time recovery (PITR) to prevent data loss.
  • Operational Management: Covers failover/switchover procedures, PgBouncer connection pooling, Prometheus monitoring, cluster hibernation for resource savings, and common troubleshooting steps.
  • Use Case: Ideal for teams running self-hosted services on Kubernetes or homelab users needing reliable, self-managed PostgreSQL without manual infrastructure work.

Quick Start

Use the cloudnative-pg skill to deploy a 3-replica high-availability PostgreSQL cluster with automated S3 backups and PgBouncer connection pooling on your Kubernetes cluster.

Frequently Asked Questions about cloudnative-pg

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I deploy a high-availability PostgreSQL cluster on Kubernetes?▼

You can deploy a high-availability PostgreSQL cluster on Kubernetes by using the CloudNativePG operator to declaratively manage multi-replica setups. This Skill automates the configuration and provisioning of production-grade clusters with Rook Ceph storage integration.

What is the best way to configure S3 backups for PostgreSQL on Kubernetes?▼

The best way to configure S3 backups for PostgreSQL on Kubernetes is through the Barman Cloud Plugin, which enables WAL archiving, scheduled backups, and point-in-time recovery (PITR) to S3-compatible storage like MinIO for disaster recovery.

Can I use PgBouncer connection pooling with a Kubernetes PostgreSQL cluster?▼

Yes, you can use PgBouncer connection pooling with a Kubernetes PostgreSQL cluster. This Skill provides guided setup for integrating PgBouncer to manage connections efficiently alongside your CloudNativePG instances.

Does CloudNativePG support automated failover and switchover operations?▼

Yes, CloudNativePG supports automated failover and switchover operations. This Skill covers the operational management procedures needed to handle node failures and maintain high availability for your PostgreSQL cluster.

How do I integrate Prometheus monitoring with PostgreSQL on Kubernetes?▼

You integrate Prometheus monitoring with PostgreSQL on Kubernetes by configuring the metrics endpoints exposed by the CloudNativePG operator. This Skill guides you through setting up cluster monitoring and troubleshooting common operational issues.

Is this approach suitable for single-instance homelab Kubernetes setups?▼

Yes, this approach is suitable for single-instance homelab Kubernetes setups. The Skill supports both simple homelab deployments and complex production high-availability clusters, reducing manual infrastructure work for self-hosted services.

Related Skills

Explore More Software Engineering Skills→
kettleofketchupkettleofketchup

rook-ceph

Deploy a Rook Ceph cluster across Kubernetes nodes using Helm.

Community
Advanced
reverb256reverb256

infrastructure-monitoring

Manage and visualize system metrics with Prometheus, Grafana, and Alertmanager.

Community
Advanced
vm0-aivm0-ai
76

minio

Manage S3-compatible object storage with MinIO Client or curl.

Official
Advanced
AbdullahMalik17AbdullahMalik17
9

deploying-postgres-k8s

Deploy PostgreSQL clusters on Kubernetes with CloudNativePG and automated failover.

Community
Advanced