Re: [GENERAL] Index corruption & broken clog

Поиск
Список
Период
Сортировка
От Benoit Lobréau
Тема Re: [GENERAL] Index corruption & broken clog
Дата
Msg-id CAPE8EZ4OQVT0VbAY2H6s2Koq6HYTroZM-EG=6RMGGrpndF2phg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Index corruption & broken clog  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: [GENERAL] Index corruption & broken clog
Список pgsql-general
Дерево обсуждения
Thanks for the help.

 
Shut down the corrupted database and make a physical backup of it.

I did it before trying anything. 
 
 
Check the disks and memory on the machine where the problem occurred.

We are using virtual machines (VMWare). I will ask then to investigate anyway.
 
You can try to salvage data from the corrupted tables, either
using "zero_damaged_pages" (but that will only work if the page
header is corrupted), or by excluding problematic tuples by their
"ctid".

Thanks will try.

В списке pgsql-general по дате отправления:

Предыдущее
От: KES
Дата:
Сообщение: Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function
Следующее
От: Benoit Lobréau
Дата:
Сообщение: Re: [GENERAL] Index corruption & broken clog