"John M. Layman" <jml@frijid.net> writes:
> pg_dump -p 6543 -b -Ft -v -o dbase | pg_restore -p 5432 -Ft -v -o -d dbase
> The above command causes pg_restore to fail with the following error:
> pg_restore: [tar archiver] could not find header for file 37.dat in tar archive
Philip Warner points out that "-o" for pg_restore means "restore in OID
order", which requires seeking in the input file, which won't work on
piped input. Try it without the -o on the restore side. (Offhand I'd
bet that you don't really want -o on the dump side, either, but that's
a different issue.)
The error messages do leave something to be desired :-(
regards, tom lane
