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!