Agent-Skills.md

Agent Skills: CNPG Cross-Region Migration

Migrate a single-instance CNPG PostgreSQL cluster between regions or region-pinned storage classes via streaming replication with sub-second downtime

UncategorizedID: agentydragon/ducktape/cnpg_region_switch

Repository

agentydragon/ducktape
agentydragon
41

Install this agent skill to your local

pnpm dlx add-skill https://github.com/agentydragon/ducktape/tree/HEAD/cluster/skills/cnpg_region_switch

Skill Files

Browse the full folder contents for cnpg_region_switch.

Download Skill

Loading file tree…

cluster/skills/cnpg_region_switch/SKILL.md

Skill Metadata

Name
cnpg_region_switch
Description
Migrate a single-instance CNPG PostgreSQL cluster between regions or region-pinned storage classes 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 one region to another (either direction)
  • 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)
  • Region and storage-class names are deployment-specific — see <../../docs/cnpg_conventions.md> for the current CNPG profiles and region-pinning rules