| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | James Thornton <thornton(at)cs(dot)baylor(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore: [archiver] input file does not appear to |
| Date: | 2002-06-24 19:55:06 |
| Message-ID: | Pine.LNX.4.21.0206242048450.14254-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-06-24 20:02:24 | Re: functions for date parsing. |
| Previous Message | Joshua D. Drake | 2002-06-24 19:38:51 | Re: website design |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-24 20:22:12 | Nonrecursive ALTER TABLE ADD/RENAME COLUMN is wrong |
| Previous Message | Oliver Teuber | 2002-06-24 19:48:05 | Alter ALTER TABLE statement ... |