Обсуждение: pg_restore: [archiver] input file does not appear to be a valid archive

I upgrade from PG 7.1.3 to 7.2, and I am trying to restore my dbs but I
keep getting:

[nsadmin@roam backup-20020622]$ pg_restore <all-good.dmp
pg_restore: [archiver] input file does not appear to be a valid archive

James Thornton <thornton@cs.ecs.baylor.edu> writes:
> I upgrade from PG 7.1.3 to 7.2, and I am trying to restore my dbs but I
> keep getting:
> [nsadmin@roam backup-20020622]$ pg_restore <all-good.dmp
> pg_restore: [archiver] input file does not appear to be a valid archive

How did you make the dump file exactly?

I'm betting that what you have is not a dump, but just a SQL script that
you are supposed to feed to psql not pg_restore ...

            regards, tom lane