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

From: Slava Moudry <slava(at)cloudflare(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13664: pg_restore fails with -j parameter when restoring 9.1 db onto 9.5 alpha db
Date: 2015-10-07 22:37:43
Message-ID: CAKQz4N90uuaS0i5AYrByR5mtCGAsX=ytqgLViERp_n=KDAcj+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> slava(at)cloudflare(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jarl Walker 2015-10-08 02:37:12 Re: BUG #13663: uuid-ossp in multiple schemas same database
Previous Message Tom Lane 2015-10-07 21:56:09 Re: BUG #13664: pg_restore fails with -j parameter when restoring 9.1 db onto 9.5 alpha db