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!
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 |