BUG #13684: pg_restore does not restore indexes when --jobs=X passed

From: cdaringe(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13684: pg_restore does not restore indexes when --jobs=X passed
Date: 2015-10-16 16:26:19
Message-ID: 20151016162619.3019.4065@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13684
Logged by: Christopher Dieringer
Email address: cdaringe(at)gmail(dot)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!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2015-10-16 17:38:38 Re: Issue with database error: ERROR: invalid page header in block 579 of relation base/24067/12574
Previous Message Michael Meskes 2015-10-16 15:33:17 Re: BUG #13676: C typedef code generated by ecpg with wrong syntax