Overview of WarehousePG Copy

The WarehousePG (WHPG) Copy utility, or whpg-copy, is a high-performance migration tool designed to move data between source and destination WHPG clusters. By executing transfers directly between segment hosts, it bypasses the coordinator node bottleneck to achieve massive throughput.

WarehousePG Copy streamlines the migration of database objects and datasets by managing the following critical tasks:

• Schema migration: Automatically replicates schemas and table structures on the destination cluster if they are not already present.
• High-velocity data transfer: Moves data efficiently using parallelized workers and optional compression to optimize network bandwidth.
• Dependency resolution: Intelligently analyzes table relationships—such as foreign keys—to ensure data is loaded in the correct logical sequence.
• Operational resilience: Provides comprehensive success and failure reporting, and automatically generates retry configurations to handle interrupted or failed tasks without restarting the entire process.