deploying-postgres-k8s

Deploy PostgreSQL clusters on Kubernetes with CloudNativePG and automated failover.

Updated Jan 6, 2026
One-click install
npx skills add https://github.com/salmanparacha/speckitplus-calculator --skill deploying-postgres-k8s-salmanparacha
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: deploying-postgres-k8s
Source: https://github.com/salmanparacha/speckitplus-calculator/tree/main/.claude/skills-nocontext/deploying-postgres-k8s
Command: npx skills add https://github.com/salmanparacha/speckitplus-calculator --skill deploying-postgres-k8s-salmanparacha

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Deploys production-ready PostgreSQL clusters on Kubernetes with automated failover, reducing manual setup and operational risk.

Core Features & Use Cases

  • Operator installation and upgrades using CloudNativePG
  • Cluster provisioning (HA with multiple replicas) and connection secrets
  • Backup configuration and disaster recovery readiness for production workloads
  • Local development and testing environments that mirror production deployments

Quick Start

Install the CloudNativePG operator, create a 3-node cluster named pg-cluster, and verify it's Ready.

Frequently Asked Questions about deploying-postgres-k8s

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

FAQPage Schema
How do I deploy a PostgreSQL cluster on Kubernetes with automated failover?

You deploy a PostgreSQL cluster on Kubernetes with automated failover by installing the CloudNativePG operator, applying Cluster resource YAML manifests to provision multiple replicas, and configuring connection secrets for a production-grade HA setup.

What is CloudNativePG used for in Kubernetes PostgreSQL cluster management?

CloudNativePG is used for Kubernetes PostgreSQL cluster management to handle operator installation, cluster provisioning with automated failover, and backup configuration for development and on-prem production workloads.

Do I need the CloudNativePG operator to set up high availability PostgreSQL on Kubernetes?

Yes, you need the CloudNativePG operator (v1.28+) to set up high availability PostgreSQL on Kubernetes, as it provides the custom resources required for cluster provisioning, automated failover, and backup configuration.

Can I configure backups and disaster recovery for a PostgreSQL cluster on Kubernetes?

You can configure backups and disaster recovery for a PostgreSQL cluster on Kubernetes by applying standard YAML manifests for backup resources alongside your CloudNativePG Cluster definitions to ensure production workload readiness.

What's the best way to provision a local development PostgreSQL cluster that mirrors production on Kubernetes?

The best way to provision a local development PostgreSQL cluster that mirrors production on Kubernetes is using standard YAML manifests with the CloudNativePG operator to create a 3-node cluster and verify it reaches Ready status.