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" <sr...@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


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to