Re: pg_restore valid archive

So I used:

psql mydb < pgmydb

and it worked like a charm.

What's the deal with pg_restore? Is it just noise? The
docs show it working. Not a big deal, but I can't get it
to work.

Thanks.

eel(at)javabox(dot)com (Eel) wrote in message news:<a62a408(dot)0202151814(dot)15a4dcc(at)posting(dot)google(dot)com>...
> Hi,
> I'm trying to upgrade to 7.2 from 7.0. I first tried pg_dump from
> 7.0 and then pg_restore. It gave me "input file does not appear to be
> a valid archive". I did a bit of research and found that versions of
> pg_dump/restore are incompatible, so I pg_dumped it from the 7.2
> pg_dump. It still gives me the same error. What do I need for a
> valid archive? I'm doing something like:
>
> pg_dump -h oldmachine mydb > pgmydb
>
> None of the following work.
> pg_restore pgmydb
> pg_restore -d mydb pgmydb
> pg_restore -d mydb -f pgmydb
>
> Is there any trick to doing this? I can't even dump/restore a simple
> database on the new machine.
>
> Thanks!