pg_dump -Fc -Z 9 -U postgres -W --file=file.dump db_name pg_restore -Fc -j 8 -U postgres -W -d db_name file.dump