Skip to content
Back to skills

Cnpg Region Switch

ASecurity

Migrate a CNPG PostgreSQL cluster between Proxmox and Hetzner regions via streaming replication with sub-second downtime

  • 11 stars
  • 0 votes
  • 0 copies
  • 1 view
  • Added September 9, 2026
databasessqldatabase

Security analysis

A100/100

Pro scans all 3 files and shows the line behind each finding

Scanned September 9, 2026

npx -y skills add agentydragon/ducktape --skill cnpg_region_switch --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Cnpg Region Switch?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Cnpg Region Switch
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/agentydragon-cnpg-region-switch-ducktape/badge)](https://www.skillsdirectory.com/skills/agentydragon-cnpg-region-switch-ducktape)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
name: cnpg_region_switch
description: Migrate a CNPG PostgreSQL cluster between Proxmox and Hetzner regions via streaming replication with sub-second downtime
---

# CNPG Cross-Region Migration

Migrate a single-instance CNPG PostgreSQL cluster between regions using the Standalone Replica Cluster pattern.

## When to use

- Migrating a database from Proxmox to Hetzner (or vice versa)
- Moving a database to region-appropriate storage
- No HA replicas exist — single-instance cluster only

## Procedure

Follow the runbook at `skills/cnpg_region_switch/RUNBOOK.md` step by step.

Key steps:

1. Create source cluster (if not existing)
2. Create target as streaming replica (`pg_basebackup` + `replica.enabled: true`)
3. Verify replication and data
4. Promote target (`spec.replica.enabled: false`)
5. Verify promoted target (writable, data intact, sequences correct)
6. Update application connection string
7. Delete source cluster

## Important constraints

- Both clusters must use the same PostgreSQL image version
- Promotion is irreversible (standalone replica pattern)
- Namespace must have quota for ≥6 services during migration (3 per cluster)

Files in this skill

  • BUILD.bazel.specimen195 B
  • RUNBOOK.md5.4 KB
  • SKILL.md1.1 KB

Attribution

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.