Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive
Date
Msg-id 21282.1024952557@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore: [archiver] input file does not appear to be a valid archive  (James Thornton <thornton@cs.baylor.edu>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Blob like type
Next
From: "Tomis³aw Kityñski"
Date:
Subject: SERIAL and RULE of "ON INSERT" kind