cnpg-database

Provision and manage PostgreSQL databases in Kubernetes with CNPG clusters.

24|3|Updated Mar 31, 2022

Search Tags:#database #postgresql #kubernetes #replication #pgbouncer #cnpg

Ready to run

npx skills add https://github.com/ionfury/homelab --skill cnpg-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: cnpg-database
Source: https://github.com/ionfury/homelab/tree/main/.claude/skills/cnpg-database
Command: npx skills add https://github.com/ionfury/homelab --skill cnpg-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

CNPG Database Management helps operators provision and manage PostgreSQL databases in a Kubernetes homelab, supporting both shared platform clusters and dedicated app clusters for isolation and scale.

Core Features & Use Cases

Shared platform cluster provisioning and governance for multi-tenant apps
Dedicated CNPG clusters for apps needing extensions, isolation, or custom configurations
Credential replication, monitoring, and network policy integration to secure access

Quick Start

Deploy CNPG on your Kubernetes cluster and begin provisioning databases for your apps using the shared platform cluster or dedicated clusters.

Frequently Asked Questions about cnpg-database

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

FAQPage Schema

How do I provision a PostgreSQL database in Kubernetes using CNPG?▼

Provisioning a PostgreSQL database in Kubernetes with CNPG involves setting up a shared platform cluster or dedicated app cluster, applying initdb configurations, and configuring extensions for workload isolation.

What is the difference between a shared platform cluster and a dedicated CNPG cluster?▼

A shared platform cluster provides multi-tenant database governance, while a dedicated CNPG cluster isolates workloads by offering custom configurations, bootstrap with initdb, and specific PostgreSQL extensions per app.

How do I set up PgBouncer connection pooling for PostgreSQL in Kubernetes?▼

PgBouncer connection pooling for PostgreSQL in Kubernetes is configured within a dedicated CNPG cluster to isolate workloads and manage pooled connections, ensuring efficient database access for applications.

Does CNPG support Prometheus monitoring and network policies for PostgreSQL clusters?▼

CNPG supports Prometheus monitoring and network policy integration for PostgreSQL clusters, ensuring secure access and observability for both shared platform and dedicated app database deployments in Kubernetes.

How do I configure credential replication for PostgreSQL in Kubernetes?▼

Configuring credential replication for PostgreSQL in Kubernetes requires setting up replication credentials within the CNPG cluster definition, ensuring database access is synchronized across instances for reliable operations.

When should I use a dedicated CNPG cluster instead of a shared PostgreSQL cluster?▼

Use a dedicated CNPG cluster when applications need specific PostgreSQL extensions, workload isolation, or custom configurations, whereas a shared cluster suits general multi-tenant database provisioning needs.