| From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_restore: archiver error |
| Date: | 2002-07-17 22:06:41 |
| Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73CE3@snt452.corp.bcbsm.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Howdy:
Running PostgreSQL 7.1.3 and migrating to PostgreSQL 7.2.1.
While trying to use the new (7.2.1) pg_dump / pg_restore to
grab the data from the 7.1.3 database, I run into an error
when I hit a table:
[snip]
/backup/pg_dump -i -Fc -d testdb | /backup/pg_restore -v -h 192.168.0.2 -d
testdb
pg_restore: [archiver (db)] could not execute query:
ERROR: Relation "ref_memmonth_spans" does not exist
pg_restore: *** aborted because of error
[/snip]
I am looking at the table on the database (in 7.1.3) and it
seems okay. My question is: what exactly is this
error talking about and why am I not able to dump the
table *by itself* but I can do the others? (Thought about
it being corrupt, but not sure how to prove that).
Thanks!
-X
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Bakken | 2002-07-17 22:57:50 | DELETE FROM error |
| Previous Message | Brendan LeFebvre | 2002-07-17 21:52:51 | Stubborn lock(?) with psqlODBC+MSAccess |