Обсуждение: BUG #13684: pg_restore does not restore indexes when --jobs=X passed

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!

cdaringe@gmail.com writes:
> 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 seems pretty unlikely that it would just "skip" them.  More probable
is that the index creation commands are failing for some reason.  Have
you looked at pg_restore's output and/or the postmaster log for clues?

If that doesn't turn up any info, can you provide a self-contained
test case?

            regards, tom lane