Re: corrupt data

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: corrupt data
Дата
Msg-id 1057967403.24304.2052.camel@camel
обсуждение исходный текст
Ответ на corrupt data  ("Zeno R.R. Davatz" <zdavatz@ywesee.com>)
Ответы corrupt data - caused by lm-sensors?  ("Zeno Davatz" <zdavatz@ywesee.com>)
Список pgsql-admin
On Fri, 2003-07-11 at 01:58, Zeno R.R. Davatz wrote:
> Hi List
>
> Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we
get:
>
> psql: ERROR:  _mdfd_getrelnfd: cannot open relation pg_type_oid_index:
> No such file or directory
>
> REINDEX does not work. We get the same error.
>
> pgfsck gives us: wrong blockseize.
>
> We are using postgresql 7.3.3-1 (debian).
>

uh oh, sounds like you might have some flakey hardware.

try vacuumdb template1 and if that gets you in you might want to do a
pg_dump and then do some hardware testing.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


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

Предыдущее
От: stephane parenton
Дата:
Сообщение: xml output
Следующее
От: "Zeno Davatz"
Дата:
Сообщение: corrupt data - caused by lm-sensors?