On Friday 19 November 2010 8:29:38 am Tom Lane wrote:
> Andreas Laggner <andreas(dot)laggner(at)vti(dot)bund(dot)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:
aklaver(at)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(dot)klaver(at)gmail(dot)com