ClickHouse Cloud introduces Postgres to Postgres ClickPipes, a fully managed migration service for moving Postgres databases between providers with minimal downtime. It automates schema dumps (handling roles, version compatibility, TLS, and idempotent retries), uses PeerDB-powered parallel initial loads to reduce large migration times from days to hours, and provides reliable CDC for continuous synchronization during cutover. The service abstracts away manual pg_dump/pg_restore workflows, offers retry mechanisms, alerting, and a step-by-step UI wizard, while also supporting a manual mode for custom workflows.
Table of contents
The complexity of Postgres migrations today #Introducing Postgres to Postgres ClickPipes #16.5K Impressions