Rich Shepard <[EMAIL PROTECTED]> 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:
>
> [EMAIL PROTECTED]:/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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
