Re: [GENERAL] pg_restore with -j fails (works without -j option)

2011-08-28 Thread Lonni J Friedman
On Sun, Aug 28, 2011 at 6:56 PM, Tom Lane wrote: > I wrote: >> Lonni J Friedman 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

Re: [GENERAL] pg_restore with -j fails (works without -j option)

2011-08-28 Thread Tom Lane
I wrote: > Lonni J Friedman 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 fri

Re: [GENERAL] pg_restore with -j fails (works without -j option)

2011-08-26 Thread Lonni J Friedman
On Thu, Aug 25, 2011 at 7:41 PM, Tom Lane wrote: > Lonni J Friedman writes: >> [ this doesn't work: ] >> $ cat 2011-08-25-1314280801-nightly.out | pg_restore -j2 -U lfriedman -v -d >> nightly > > It's basically impossible for that to work.  -j implies spawning > multiple processes that will be w

Re: [GENERAL] pg_restore with -j fails (works without -j option)

2011-08-25 Thread Tom Lane
Lonni J Friedman writes: > [ this doesn't work: ] > $ cat 2011-08-25-1314280801-nightly.out | pg_restore -j2 -U lfriedman -v -d > nightly It's basically impossible for that to work. -j implies spawning multiple processes that will be wanting to read concurrently from different places in the inp