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

Sun, 23 Jun 2002 00:12:11 -0500
James Thornton <thornton@cs.baylor.edu>
pg_restore: [archiver] input file does not appear to be a valid
	archive
On Sun, 23 Jun 2002, James Thornton wrote:

> 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


Well we could try and work out the problem and a solution on the assumption
that the dump is a valid archive or you could confirm that it is first.

Just look at the file. I believe I'm right, but accept I may be wrong, in
saying that the 7.1.3 pg_dump can only generate a script file. So if it's valid
it should look like a script to recreate and load your database. You could
try running it straight into psql as well.


-- 
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants




Mon, 24 Jun 2002 20:55:06 +0100 (BST)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: pg_restore: [archiver] input file does not appear to
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



Mon, 24 Jun 2002 17:02:37 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pg_restore: [archiver] input file does not appear to be
	a valid archive