Lonni J Friedman <netllama@xxxxxxxxx> 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 input file. That cannot happen when the source is a pipe. In this particular example, the pipe construct isn't even doing anything useful; you could perfectly well write this instead: $ pg_restore -j2 -U lfriedman -v -d nightly 2011-08-25-1314280801-nightly.out > 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
