Re: missing chunk number 0 for toast value ...

From: MIlos Prudek <prudek(at)bvx(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: missing chunk number 0 for toast value ...
Date: 2006-05-05 17:49:33
Message-ID: 200605051949.33397.prudek@bvx.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vadim Pestovnikov 2006-05-05 21:02:52 handling errors of os.error module
Previous Message Joshua D. Drake 2006-05-05 16:48:29 Re: Best way to upgrade Postgresql 7.4.x to 8.1.x?