Re: trouble migrating large objects from 7.1.3 to 7.3.2

"John M. Layman" <jml@frijid.net> writes:
> I'm using the following command to migrate the data:

> pg_dump -p 6543 -b -Ft -v -o dbase | pg_restore -p 5432 -Ft -v -o -d dbase

The tar-archive code seems to have some bugs in it :-(.  I will look at
that, but the primary problem you are going to face here is that
pg_restore needs to seek in the dump file to implement this operation,
and it can't seek a pipe.

I think you will need to (a) use -Fc not -Ft, and (b) write the dump to
a temp file that pg_restore reads as a separate operation.

            regards, tom lane