BUG #13684: pg_restore does not restore indexes when --jobs=X passed - Mailing list pgsql-bugs

From cdaringe@gmail.com
Subject BUG #13684: pg_restore does not restore indexes when --jobs=X passed
Date
Msg-id 20151016162619.3019.4065@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13684: pg_restore does not restore indexes when --jobs=X passed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13684
Logged by:          Christopher Dieringer
Email address:      cdaringe@gmail.com
PostgreSQL version: 9.4.2
Operating system:   Ubuntu 14.04 64-bit (64)
Description:

Hi all:

I have read the documentation on pg_restore using --jobs.  Unfortunately,
when I run the pg_restore command with --jobs=4 or --jobs=6, it _skips_
re-adding indexes to my tables.

It states that --jobs only works with the c format.  My dumps are generated
and restored via:

pg_dump --verbose -Fc -p 6117 -f '/path/to/network/storage/db.dump'  # pg
9.4.4, ubu 14.04
cp /path/to/network/storage/db.dump /local/path/dbdump
pg_restore -vd  coins_temp /local/path/dbdump # pg 9.4.2, ubu 14.04

This really threw me for a loop.  Apologies if I'm missing something
obvious, but I did run it by some peers prior to report :)

Thanks!

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
Next
From: John McKown
Date:
Subject: Re: BUG #13676: C typedef code generated by ecpg with wrong syntax