From: MIlos Prudek <prudek@bvx.cz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: missing chunk number 0 for toast value ...
Date: Fri, 5 May 2006 19:49:33 +0200
Message-ID: <200605051949.33397.prudek@bvx.cz> (raw)
In-Reply-To: <25742.1146688817@sss.pgh.pa.us>
References: <200605032202.57825.prudek@bvx.cz>
<25742.1146688817@sss.pgh.pa.us>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: prudek@bvx.cz, tgl@sss.pgh.pa.us
Subject: Re: missing chunk number 0 for toast value ...
In-Reply-To: <200605051949.33397.prudek@bvx.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox