Hacker News new | ask | show | jobs
by saisrirampur 787 days ago
OP here. pgcopydb is also a great tool. It does pg_dump|pg_restore. It cannot multi-thread (parallelize) single table data migration
2 comments

seems like it can parallelize to an extent: https://pgcopydb.readthedocs.io/en/latest/concurrency.html#s...
It only uses pg_dump and pg_restore for transfer of the schema, the actual data transfer is a custom mechanism.