Funded upstream maintenance

pgcopydb Maintenance and Priority Support

PostgreSQL major-version upgrades and provider moves, with a cutover window you choose

pgcopydb copies a PostgreSQL database to a target server using logical replication and parallel workers, while the source stays online. It is the practical path for a major-version upgrade or a cross-cloud move where pg_dump downtime is unacceptable — and it is what Azure Database for PostgreSQL’s official Migration Service runs on.

1,531GitHub stars 90k+databases migrated inside Azure v0.18Jun 2026
See Pricing & Tiers View on GitHub

What pgcopydb Does in an Upgrade

Live database cloning with logical replication

pgcopydb copies a PostgreSQL database from source to target while the source remains online. It uses logical replication to keep the target in sync and only requires a short maintenance window for the final cutover.

Why it matters

Database migrations are complex and risky

  • pg_dump and pg_restore cause significant downtime on large databases
  • Binary-incompatible versions and cross-cloud moves rule out streaming replication
  • pgcopydb handles the full copy lifecycle with a short, predictable cutover window
  • Built for edge cases: large objects, sequences, indexes, and constraints

Typical use cases

Where pgcopydb fits

  • PostgreSQL major version upgrades with minimal downtime
  • Cloud-to-cloud or on-premise-to-cloud migrations
  • Creating read replicas across incompatible versions
  • Database cloning for staging and testing environments

Key capabilities

Built for production databases

  • Logical replication for live copy with change tracking
  • Parallel workers for table data, indexes, and constraints
  • Table and schema filtering
  • Large object support
  • Progress tracking and resume on failure

What’s Being Worked On Right Now

Active maintenance areas

Current work focuses on logical replication performance, broader data type coverage, improved progress reporting, and PostgreSQL version compatibility across all supported major versions.

The full backlog for this project — last release, what has merged since, and the big features queued behind it — is on the roadmap page, kept current rather than summarised here.

Install pgcopydb

Open source and available now

pgcopydb is open source, actively developed, and available for Linux. Packages are available for Debian, Ubuntu, and RPM-based distributions.

The pgcopydb documentation covers filtering, resume-on-failure, and the follow-mode cutover in detail.

GitHub Documentation

Fund pgcopydb Maintenance

Keep your upgrade path supported

Microsoft, PlanetScale, Neon, Timescale and Meltwater all run pgcopydb in production. If your major-version upgrade or provider migration depends on it, funding its maintenance buys a defined response time on the bug you hit during the cutover window — the one moment when waiting is most expensive.

Work is prioritized through one queue across all four projects, triaged against your tier’s SLA, and shipped in quarterly releases — upstream, open source, for everyone.

See Pricing & Tiers See This Project’s Backlog

Get More Out of the PostgreSQL You Already Run

One learning path, four ways in — from The Art of PostgreSQL

Funded maintenance keeps the tools working. How much you get out of PostgreSQL itself is a different problem — query design, data modelling, and knowing which of its features you are not using. That is what the rest of The Art of PostgreSQL is for.

These aren’t four separate products. They’re one path: start with the book for the foundations, take the course to structure and deepen them, join a masterclass when you want to go further on a specific topic with the author in the room — and license it for the team when it should be everyone’s baseline, not one person’s.

Book

Read it yourself. SQL and data modelling from the ground up — the foundation the rest builds on.

Course

Work through it. Structured modules and hands-on exercises against real datasets, at your own pace.

Masterclass

Ask questions live. Three-hour sessions with the author on one topic, or the full curriculum.

Team

Bring the whole team. Per-seat licensing from five people up, with a dashboard to manage progress.

Copyright 2026 © Dimitri Fontaine. All rights reserved.