"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
