Re: pg_restore with -j fails (works without -j option) - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore with -j fails (works without -j option)
Date
Msg-id 25525.1314583000@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore with -j fails (works without -j option)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore with -j fails (works without -j option)  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
I wrote:
> Lonni J Friedman <netllama@gmail.com> writes:
>> [ this doesn't work: ]
>> $ cat 2011-08-25-1314280801-nightly.out | pg_restore -j2 -U lfriedman -v -d nightly
>> pg_restore: [custom archiver] cannot reopen stdin
>> pg_restore: *** aborted because of error

> I agree though that that's not a terribly friendly error message.
> I thought we had some code in there to complain about non-seekable
> input files, but it looks like we missed a case.

On closer inspection, I think it's just that nobody thought very hard
about presenting this limitation in a user-friendly fashion.  I've
committed a patch that will make it fail like this:

pg_restore: [custom archiver] parallel restore from stdin is not supported

immediately upon startup.

            regards, tom lane

pgsql-general by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: Problem importing a csv file
Next
From: Lonni J Friedman
Date:
Subject: Re: pg_restore with -j fails (works without -j option)