Copying a database | Postgres.FM 028 |
Michael and Nikolay discuss options for copying a database — what the various options are, how to copy large databases, and some pointers on performance.
Here are links to a few things we mentioned:
pg_dump https://www.postgresql.org/docs/curre...
pg_restore https://www.postgresql.org/docs/curre...
pgcopydb (tool by Dimitri Fontaine) https://github.com/dimitri/pgcopydb
pg_dump and external snapshots (blog post by Michael Paquier) https://paquier.xyz/postgresql-2/post...
Systems Performance (book by Brendan Gregg) https://www.brendangregg.com/systems-...
Performance troubleshooting methodologies (two part talk by Brendan Gregg) • Linux Performance Tools, Brendan Greg...
pg_basebackup https://www.postgresql.org/docs/curre...
wal-g https://github.com/wal-g/wal-g
pgBackRest https://pgbackrest.org/
Database Lab Engine https://github.com/postgres-ai/databa...
Database branching episode https://postgres.fm/episodes/database...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.