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  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: table corrupted
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: (WIP) VACUUM REWRITE - CLUSTER by ctid