BUG #13664: pg_restore fails with -j parameter when restoring 9.1 db onto 9.5 alpha db

slava@cloudflare.com writes:

I am trying to restore 9.1 dump into new 9.5 database.
pg_restore seems to hang indefinitely (not doing anything) when I set number
of jobs: "-j 4".
works fine if skipping "-j" setting. On same machine, 9.1 restores fine on
same host.

Impossible to do anything with this report with that much detail.
Can you look into pg_stat_activity to see what the pg_restore jobs
are doing when activity ceases? Can you show us the declarations
of the tables or other objects they're working on?

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

can't reproduce.. was able to restore with "-j 4" from 9.1
probably weird connection issue that caused pg_dump to stuck. I was using
samsung usb3 ssd, so could be hardware related.
thank you.
-slava.

On Wed, Oct 7, 2015 at 2:56 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

slava@cloudflare.com writes:

I am trying to restore 9.1 dump into new 9.5 database.
pg_restore seems to hang indefinitely (not doing anything) when I set

number

of jobs: "-j 4".
works fine if skipping "-j" setting. On same machine, 9.1 restores fine

on

same host.

Impossible to do anything with this report with that much detail.
Can you look into pg_stat_activity to see what the pg_restore jobs
are doing when activity ceases? Can you show us the declarations
of the tables or other objects they're working on?

regards, tom lane

--
-Slava