Re: missing chunk number 0 for toast value ... - Mailing list pgsql-admin

From MIlos Prudek
Subject Re: missing chunk number 0 for toast value ...
Date
Msg-id 200605051949.33397.prudek@bvx.cz
Whole thread Raw
In response to Re: missing chunk number 0 for toast value ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
> Find the row containing the busted toast reference, and delete that row
> (or just UPDATE it with some new value for the toasted column).  You can
> home in on it with the usual sorts of search methods --- look in the PG
> list archives for previous discussions of locating corrupted rows.

Thanks Tom. I ended up restoring the table from the last dump (created by
pg_dump) up to the point where corruption starts. Not the most surgical
solution but justified for my use case.


--
Milos Prudek

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?
Next
From: "Vadim Pestovnikov"
Date:
Subject: handling errors of os.error module