"Scott Reed" <sreed(at)avacoda(dot)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