how to fix missing chunk number 0?

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

Browse pgsql-general by date

  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.