James Thornton <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster