Sign in to confirm you’re not a bot
This helps protect our community. Learn more

How to copy a Postgres database? | Citus Con: An Event for Postgres 2023

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
4K views 2 years ago #PostgreSQL #Database #CitusCon
Video of a conference talk by Dimitri Fontaine about how to copy a Postgres database from a server to another server, delivered at Citus Con: An Event for Postgres 2023. How to copy a Postgres database is a frequently asked question with surprisingly few answers, most of them being quite poor. This is why Dimitri started working on pgcopydb, a new Open Source tool that's available precisely to answer this question. In this talk, you will see what makes the topic more interesting than it first seems, and how to fully answer the question, including Capture Data Changes implementation. Dimitri Fontaine is a PostgreSQL Major Contributor (design, review, Extensions, Event Triggers, etc). Dimitri maintains and develops pg_auto_failover, pgcopydb, pgloader and other software. Dimitri has also written “The Art of PostgreSQL”, a book that teaches application developers to replace thousands of lines of code with simple SQL queries. ► Video bookmarks:  …...more
...more
How to copy a Postgres database? | Citus Con: An Event for Postgres 2023
78Likes
4,036Views
2023Apr 18
Video of a conference talk by Dimitri Fontaine about how to copy a Postgres database from a server to another server, delivered at Citus Con: An Event for Postgres 2023. How to copy a Postgres database is a frequently asked question with surprisingly few answers, most of them being quite poor. This is why Dimitri started working on pgcopydb, a new Open Source tool that's available precisely to answer this question. In this talk, you will see what makes the topic more interesting than it first seems, and how to fully answer the question, including Capture Data Changes implementation. Dimitri Fontaine is a PostgreSQL Major Contributor (design, review, Extensions, Event Triggers, etc). Dimitri maintains and develops pg_auto_failover, pgcopydb, pgloader and other software. Dimitri has also written “The Art of PostgreSQL”, a book that teaches application developers to replace thousands of lines of code with simple SQL queries. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:24 How to copy a Postgres database? ⏩ 07:32 Introducing pgcopydb ⏩ 09:24 The 10 steps of pgcopydb clone ⏩ 13:21 pgcopydb concurrency and features ⏩ 15:32 Privileges & pgcopydb ⏩ 17:26 Change Data Capture ⏩ 19:04 Database Migration Complexity ⏩ 21:35 The 7 steps of pgcopydb follow ✅ Learn more: Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   #CitusCon #PostgreSQL #Database

Follow along using the transcript.

Microsoft Developer

589K subscribers