Re: table corrupted

I don't be able to select the data from table with pg_dump or select, both
occur error...
how i can identified the register of a table independent the contends of the
register, only control of the postgres?
I eliminate the index pk but now I don't be able to create begin because
show the error:
ERROR: index row requires 21776744 bytes, maximum size is 8191
How increase the index row?

--
João Eugenio Marynowski
(41) 9624-3933

2009/10/23 Robert Haas <robertmhaas(at)gmail(dot)com>

> On Thu, Oct 22, 2009 at 10:34 PM, João Eugenio Marynowski
> <joaoem(at)gmail(dot)com> wrote:
> > The hardware is ok because we have migrated to other machine and the
> errors
> > is the same
> > zero_damaged_pages is on and the vaccum verbose don't show any error...
>
> You need to dump (or otherwise extract) your data and load it into a
> new cluster. The one you have sounds like it's in bad shape.
>
> ...Robert
>