eel@javabox.com (Eel) writes:
> 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:
If you're dumping in straight SQL format (the default), just use
'psql' to do the restore:
$ psql -f <dumpfile> <dbname>
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863