From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | how to fix missing chunk number 0? |
Date: | 2003-06-25 15:44:29 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB05FED4BC@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy
Migrating PostgreSQL 7.2.1 on RedHat Linux 7.2.
I'm trying to dump my tables and have ran into a
severe problem. When I try to pg_dump tables,
they fail and I get an error:
[snip]
pg_dump: query to obtain definition of view "t_ref_hedis_ce" failed:
ERROR: missing chunk number 0 for toast value 2085599783
[/snip]
The problem is, I can't look at the pg_toast_2085599783 because
it doesn't exist (as per the suggestions at groups.google.com)
I can not vacuum or otherwise try to drop the view because
I get the same error. At the same time, I looked in the
~/pgsql/data/base/19643563/<OID> and saw that the OID
was gone. I *touched* a new one and gave it postgres:postgres
ownership and tried to drop it again.
I got the same error as above.
How can I fix this? I really need to pg_dump some data
in order to move it.
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-06-25 15:51:30 | Re: Physical Database Configuration |
Previous Message | Mike Benoit | 2003-06-25 15:42:04 | Re: Alternative replication method. |