On Thu, Aug 25, 2011 at 7:41 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Lonni J Friedman <netll...@gmail.com> 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
Indeed, that works perfectly. thanks! > > >> 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. Let me know if you need more details from me to fix this. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
