On Friday 19 November 2010 8:29:38 am Tom Lane wrote: > Andreas Laggner <andreas.lagg...@vti.bund.de> 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: akla...@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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general