Re: table corrupted
От | João Eugenio Marynowski |
---|---|
Тема | Re: table corrupted |
Дата | |
Msg-id | 840f304c0910222000y1451ce13rb34275edda020e30@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: table corrupted (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: table corrupted
|
Список | pgsql-hackers |
I don't be able to select the data from table with pg_dump or select, both occur error...<br />how i can identified the registerof a table independent the contends of the register, only control of the postgres?<br />I eliminate the index pkbut now I don't be able to create begin because show the error:<br /> ERROR: index row requires 21776744 bytes, maximumsize is 8191<br />How increase the index row?<br /><br clear="all" />--<br />João Eugenio Marynowski<br />(41) 9624-3933<br/><br /><br /><div class="gmail_quote">2009/10/23 Robert Haas <span dir="ltr"><<a href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>></span><br/><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Thu, Oct22, 2009 at 10:34 PM, João Eugenio Marynowski<br /> <<a href="mailto:joaoem@gmail.com">joaoem@gmail.com</a>> wrote:<br/> > The hardware is ok because we have migrated to other machine and the errors<br /> > is the same<br />> zero_damaged_pages is on and the vaccum verbose don't show any error...<br /><br /></div>You need to dump (or otherwiseextract) your data and load it into a<br /> new cluster. The one you have sounds like it's in bad shape.<br /><fontcolor="#888888"><br /> ...Robert<br /></font></blockquote></div><br />
В списке pgsql-hackers по дате отправления: