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.