3 ms·
OP here. pgcopydb is also a great tool. It does pg_dump|pg_restore. It cannot multi-thread (parallelize) single table data migration
by saisrirampur 2y ago
OP here. pgcopydb is also a great tool. It does pg_dump|pg_restore. It cannot multi-thread (parallelize) single table data migration
- fyrn_ 2y agoIt only uses pg_dump and pg_restore for transfer of the schema, the actual data transfer is a custom mechanism.
- lmz 2y agoseems like it can parallelize to an extent: https://pgcopydb.readthedocs.io/en/latest/concurrency.html#same-table-concurrency https://pgcopydb.readthedocs.io/en/latest/concurrency.html#s...