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