Re: How can I find a broken row in a table - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How can I find a broken row in a table
Date
Msg-id 4BC82D5502000025000309D8@gw.wicourts.gov
Whole thread Raw
In response to How can I find a broken row in a table  (Khangelani Gama <Khangelani.Gama@ucs-software.co.za>)
List pgsql-admin
Khangelani Gama <Khangelani.Gama@ucs-software.co.za> wrote:

> there is a table that has a broken row, but now I don't know which
> one is broken. the table has about 20974 pages.

If there are any indexes on the table which haven't been corrupted,
you might try selecting ranges of rows using one of them, capturing
the undamaged data into a new table.  By subdividing damaged ranges
you can do a sort of "binary search" for the bad rows while
recovering the good ones.

-Kevin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How can I find a broken row in a table
Next
From: Tom Lane
Date:
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"