May 2018
Intermediate to advanced
576 pages
30h 25m
English
Recreate the database in the original server using parallel tasks to speed things along. This can be executed remotely without needing to transfer the dumpfile between systems, as shown in the following example, where we use the -j option to specify four parallel processes:
pg_restore -h myhost -d postgres --create -j 4 dumpfile