Rich Shepard <rshepard(at)appl-ecosys(dot)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(at)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