---
title: "Introducing Postgres to Postgres ClickPipes in ClickHouse Cloud"
description: "Postgres-to-Postgres migrations between providers can require manual schema handling, data movement, CDC, and cutover coordination, with risks around database objects and long-running loads. Postgres to Postgres ClickPipes, now in public beta, provides a fully managed migration service in ClickHouse Cloud designed to reduce operational overhead and support minimal downtime. It automates schema dump and restore, including secure connections, role conflicts, version differences, transactional application, retries, and UI or notification-based error reporting, while PeerDB supplies parallel initial loads and CDC capabilities. Independent pull and push processes use retries and alerting for transient errors, and the roadmap includes features to assist with cutover into Postgres by ClickHouse."
---

# Introducing Postgres to Postgres ClickPipes in ClickHouse Cloud

[Clickhouse](https://yomu.fyi/company/clickhouse) · Jun 11, 2026

**Type:** Announcement

## Summary

Postgres-to-Postgres migrations between providers can require manual schema handling, data movement, CDC, and cutover coordination, with risks around database objects and long-running loads. Postgres to Postgres ClickPipes, now in public beta, provides a fully managed migration service in ClickHouse Cloud designed to reduce operational overhead and support minimal downtime. It automates schema dump and restore, including secure connections, role conflicts, version differences, transactional application, retries, and UI or notification-based error reporting, while PeerDB supplies parallel initial loads and CDC capabilities. Independent pull and push processes use retries and alerting for transient errors, and the roadmap includes features to assist with cutover into Postgres by ClickHouse.

## Context

Migrating Postgres between providers can involve installing and coordinating command-line tools, handling schema dumps and restores, preserving indexes, constraints, sequences, triggers, and other objects, and monitoring slow or opaque loads. Online migrations also depend on reliable CDC to keep the destination synchronized before cutover.

## Approach / What changed

Postgres to Postgres ClickPipes is a fully managed migration service in ClickHouse Cloud. It performs schema dump and restore under the hood, supports secure source connections, handles role and version differences, applies dumps transactionally with a single round-trip connection, and surfaces errors in the UI and through notifications. PeerDB provides parallel initial loads and CDC, while independent pull and push processes use retries and alerting. A manual mode remains available for specialized workflows.

## Takeaways

- Automated schema migration covers secure connections, role conflicts, source and target version differences, transactional application, and idempotent retries without requiring users to run pg\_dump or psql.
- PeerDB powers parallel initial loads and CDC, including automatic column addition propagation and TOAST support to help avoid costly resynchronization during cutover.
- ClickPipes runs schema dumps and initial loads close to the source database, and its independent pull and push processes retry transient errors and trigger UI or email notifications after failed retries.

**Tags:** [Migrations](https://yomu.fyi/topic/migration), [Performance](https://yomu.fyi/topic/performance), [Postgres](https://yomu.fyi/topic/postgres), [Reliability](https://yomu.fyi/topic/reliability)

- Source: [Clickhouse](https://clickhouse.com/blog/clickpipes-postgres-to-postgres)
- Source URL: https://clickhouse.com/blog/clickpipes-postgres-to-postgres
- Ingested by Yomu: 2026-08-29T01:35:01.819Z

[Read original post](https://clickhouse.com/blog/clickpipes-postgres-to-postgres)