On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote: > [EMAIL PROTECTED] /usr4/postgres-backups]$ pg_restore -U postgres < > pg814data.sql > pg_restore: [archiver] input file does not appear to be a valid archive > > But it was created using the 8.3.3 pg_dumpall in /usr/bin/.
Did you use a non-ascii dump format? Try psql -U postgres -f pg814data.sql A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general