Re: corruption since 7.4.13 update ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: corruption since 7.4.13 update ?
Дата
Msg-id 23854.1152837610@sss.pgh.pa.us
обсуждение исходный текст
Ответ на corruption since 7.4.13 update ?  (FM <dist-list@LEXUM.UMontreal.CA>)
Список pgsql-admin
FM <dist-list@LEXUM.UMontreal.CA> writes:
> I'e got a very strange (scary) problem.

> ERROR:  could not read block 81235 of relation "pg_largeobject":
> Input/output error

This one is very strongly indicative of a disk hardware problem.
The others look like they could be consequences of catalog corruption
ensuing from a flaky disk.

If I were you I'd run some hardware diagnostics.  Also see if you can
pg_dump ...

            regards, tom lane

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

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Determining object name from filenode
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Table size growing for no reason