Обсуждение: pg_restore: archiver error
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
-----Original Message-----
From: terry@greatgulfhomes.com [mailto:terry@greatgulfhomes.com]
Sent: Wednesday, July 17, 2002 6:20 PM
To: Johnson, Shaunn
Subject: RE: [GENERAL] pg_restore: archiver errorIf the database was created with 7.1.x, I believe you have to use pg_dump built for that version of the database. I think you will find that the pg_dump from 7.2.x is not backwards compatible.Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Johnson, Shaunn
Sent: Wednesday, July 17, 2002 6:07 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pg_restore: archiver errorHowdy:
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