Khangelani Gama <Khangelani.Gama@xxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
