Re: [HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Thornton <thornton(at)cs(dot)ecs(dot)baylor(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive
Date: 2002-06-24 21:02:37
Message-ID: 21282.1024952557@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

James Thornton <thornton(at)cs(dot)ecs(dot)baylor(dot)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(at)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Weston 2002-06-24 21:43:11 Re: Need help on index!!!
Previous Message Ian Harding 2002-06-24 20:52:08 Re: PostgreSQL now part of the Lindows "Click-n-Run"

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-24 21:16:01 Re: Index Scans become Seq Scans after VACUUM ANALYSE
Previous Message David M. Kaplan 2002-06-24 20:51:27 new ident-des patch