EPISODE · Jan 13, 2023 · 39 MIN
Copying a database
from Postgres FM · host Nikolay Samokhvalov and Michael Christofides
Here are links to a few things we mentioned: pg_dump pg_restore pgcopydb (tool by Dimitri Fontaine) pg_dump and external snapshots (blog post by Michael Paquier) Systems Performance (book by Brendan Gregg) Performance troubleshooting methodologies (two part talk by Brendan Gregg) pg_basebackup wal-g pgBackRest Database Lab Engine Database branching episode ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.If you would like to share this episode, here's a good link (and thank you!)Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
What this episode covers
Nikolay and Michael discuss copying a database — what the various options are, how to copy large databases, and some pointers on performance.
NOW PLAYING
Copying a database
No transcript for this episode yet
Similar Episodes
Dec 4, 2025 ·32m
Nov 8, 2025 ·36m
Sep 18, 2025 ·26m