Tom,
My apologies for wasting your time. I wasn't calling pg_restore as I'd
described but with the -f flag so of course it was hanging waiting for
input. I hope my embarrassment is sufficient punishment.
Would you accept the second part of that post about handling the file
name in pgAdmin Backup and Restore? I will resubmit if you think it
would be useful.
Scott
Tom Lane [3/10/2009 3:43 PM] wrote:
> "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
>
>