pg_restore -U app -d appdb -j 4 appdb.dump

Category: Databases & SQL

pg_restore -U app -d appdb -j 4 appdb.dump

Restore a dump with parallel workers

Restores a custom-format dump using four concurrent jobs with -j, which can speed up large restores substantially. The target database must exist first. Parallel restore cannot reorder dependent objects, so it may fail on some dumps; retry with -j 1.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.