How to copy a Postgres database?

on YouTube ↗28m

" summary

A new open source tool, pgcopydb, implements a practical answer: it uses pg_dump/pg_restore for schema but streams table data with a custom COPY protocol, runs pgcopydb clone as a reproducible 10 steps pipeline, copies tables in parallel, chunks huge tables, builds indexes concurrently (including primary keys), does COPY FREEZE and VACUUM, resumes after interruptions, migrates roles via pg_dumpall, and supports Change Data Capture with logical decoding and wal2json compatibility using --follow to catch and replay changes; large objects aren’t CDC-replicated.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 1:24How to copy a Postgres database?
3. 7:32Introducing pgcopydb
4. 9:24The 10 steps of pgcopydb clone
5. 13:21pgcopydb concurrency and features
6. 15:32Privileges & pgcopydb
7. 17:26Change Data Capture
8. 19:04Database Migration Complexity
9. 21:35The 7 steps of pgcopydb follow

" related talks

• 51mWhen Postgres Can't, You Can!Keith Fiske · PostgresOpen 2013
• 50mPostgreSQL Backup and Recovery MethodsKevin Kempter · PostgresOpen 2013
• 46mAn ultimate guide to upgrading your PostgreSQL installationIlya Kosmodemiansky · PostgresOpen Silicon Valley 2017
• 25mPG Extractor - A smarter pg dumpKeith Fiske · Postgres Open 2012
• 49mTools for Creating PostgreSQL BackupsAndrey Salnikov · HighLoad++ Moscow 2018
• 37m​Postgres at Any Scale​Will Leinweber · RailsConf 2017
• 45mSQL Server to PostgreSQL: Migration Challenges & SolutionsSameer Kumar, Roneel Rohitesh Kumar · FOSSASIA PGDay 2025
• 56mPostgreSQL Backup StrategiesMagnus Hagander · Postgres Open 2012