Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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
