Re: BUG #4699: pg_restore hangs with incorrect file format

"Scott Reed" <sreed@avacoda.com> writes:
> "pg_restore <filename>" hangs if the file format is not one of the
> non-plain-text formats created by pg_dump.

When I try to reproduce this I get
pg_restore: [archiver] input file does not appear to be a valid archive

Perhaps there are specific cases where it gets confused, but you'll need
to submit a sample file for us to poke at.

Another possible explanation is that this is a bug that's been fixed
since whichever 8.3.x release you are using (which you didn't specify,
tut tut).

            regards, tom lane