On Friday 19 November 2010 8:29:38 am Tom Lane wrote: > Andreas Laggner <andreas.laggner@xxxxxxxxxxx> writes: > > i cannot restore my data from 8.2 to 8.4 because i always get this error > > message, does anyone know what to do?? > > It sounds like you're trying to use pg_restore on a plain-text (SQL > script) dump file. Run it through psql, instead. > > regards, tom lane Out of curiosity what would trigger this? When I have tried to run a plain text file through pg_restore I get: aklaver@tucker:~$ pg_restore -d test -U postgres test.sql pg_restore: [archiver] input file does not appear to be a valid archive -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
