菜单
CloudNativePG (CNPG) operator for PostgreSQL on Kubernetes. Use when deploying clusters, PgBouncer, S3/MinIO backups, WAL archiving, PITR, Prometheus monitoring, failover, or troubleshooting CNPG.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | cloudnative-pg |
| description | CloudNativePG (CNPG) operator for PostgreSQL on Kubernetes. Use when deploying clusters, PgBouncer, S3/MinIO backups, WAL archiving, PITR, Prometheus monitoring, failover, or troubleshooting CNPG. |
Kubernetes operator for PostgreSQL. Shared-nothing architecture: each instance has dedicated storage, managed directly by operator (not StatefulSet).
helm repo add cnpg https://cloudnative-pg.github.io/charts
helm repo update
helm install cnpg cnpg/cloudnative-pg -n cnpg-system --create-namespace
kubectl -n cnpg-system wait --for=condition=ready pod -l app.kubernetes.io/name=cloudnative-pg --timeout=300s
Install kubectl plugin: curl -sSfL https://github.com/cloudnative-pg/cloudnative-pg/raw/main/hack/install-cnpg-plugin.sh | sudo sh -s -- -b /usr/local/bin
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: my-db
namespace: databases
spec:
instances: 1
storage:
size: 10Gi
storageClass: ceph-block
bootstrap:
initdb:
database: app
owner: app
Services created: my-db-rw (primary), my-db-ro (replicas), my-db-r (any readable).
Credentials in Secrets: my-db-app (app user), my-db-superuser (if enabled).
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: my-db
spec:
instances: 3
storage:
size: 20Gi
storageClass: ceph-block
postgresql:
parameters:
shared_buffers: "256MB"
effective_cache_size: "768MB"
resources:
requests:
memory: "512Mi"
cpu: "250m"
limits:
memory: "1Gi"
enableSuperuserAccess: trueapp database owned by app userkubectl cnpg status my-db -n databases
kubectl get cluster my-db -n databases
kubectl get pods -l cnpg.io/clusterName=my-db -n databases -L role -o wide
# Port-forward
kubectl port-forward svc/my-db-rw 5432:5432 -n databases
# From within cluster
psql "host=my-db-rw.databases.svc dbname=app user=app"
references/cluster-examples.md - Detailed single + HA cluster manifestsreferences/backup-s3.md - Barman Cloud Plugin, S3/MinIO object store setupreferences/backup-schedule-wal.md - Scheduled backups, WAL archiving, retentionreferences/restore-pitr.md - Recovery bootstrap, PITR targetsreferences/pooler-pgbouncer.md - PgBouncer connection poolingreferences/monitoring.md - Prometheus metrics, PodMonitor, custom queriesreferences/roles-pgconfig.md - Declarative roles, PostgreSQL configurationreferences/kubectl-cnpg.md - Plugin commands referencereferences/operations.md - Failover, switchover, hibernate, maintenancereferences/troubleshooting.md - Diagnostics, common issuesReviews code comments across languages before a PR opens. Use when finishing a development branch, before merging, or when a pr create was blocked pending comment review.
Create, promote, categorize, and validate skills for the kettleofskills marketplace. Use when syncing dotfiles skills into the marketplace, adding skills, assigning categories, or preparing a release.
Build Go terminal UIs (TUIs) and CLIs with charmbracelet — Bubble Tea runtime, Lip Gloss styling, Bubbles components, Glamour markdown, Harmonica animation, BubbleZone mouse. For any bubbletea TUI.
Copier templating — author copier.yml templates (questions, Jinja, _tasks, migrations), scaffold via `copier copy`, sync via `copier update`. Use for copier.yml, .copier-answers.yml, or .jinja.
Copyparty portable file server (HTTP/WebDAV/FTP/SFTP/SMB). This skill should be used when deploying via Docker/pip/NixOS, configuring accounts/volumes, indexer, hooks, or forward-auth IdP integration.
Sway tiling Wayland compositor on NixOS. This skill should be used when configuring programs.sway, GPU rendering (Intel/AMD/NVIDIA), Wails/webkit2gtk fixes, xdg portals, home-manager, or wallpapers.