Re: Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <rshepard@appl-ecosys.com> writes:

>    Using the 8.1.2 pg_dumpall from the 2004 data directory produces a 819K
> file. But, when I then cd to the new data directory and run:
>
> postgres@salmo:/var/lib/pgsql/data$ pg_restore /var/tmp/backup.sql
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> However, the file is readable and looks to have all the databases and tables
> in it. Perhaps I'm closer now?

Yes, as I said before, 'pg_dumpall' only produces SQL format dumps,
which you restore using 'psql'.  'pg_restore' is only for binary
dumps.

-Doug