Re: pg_dump: dumpBlobs(): error reading large object: ERROR:

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: dumpBlobs(): error reading large object: ERROR:
Дата
Msg-id 5791.1058466750@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump: dumpBlobs(): error reading large object: ERROR:  (Sergio Pili <sergio.pili@spm.com.ar>)
Ответы Re: pg_dump: dumpBlobs(): error reading large object: ERROR:  (Dani Oderbolz <oderbolz@ecologic.de>)
Список pgsql-admin
Sergio Pili <sergio.pili@spm.com.ar> writes:
> pg_dump abort with this error:
> pg_dump: dumpBlobs(): error reading large object: ERROR:  cannot read block
> 6389 of pg_largeobject_loid_pn_index: Input/output error

> This error is caused by bad block on my  hard drive?

Looks like it.

> How can i do to recover database without lost blobs? Or to lose less
> information?

If the only loss is in that index, you can rebuild the index using
REINDEX.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Arrays in pl/pgsql functions
Следующее
От: Charles Haron
Дата:
Сообщение: Adding PL/Perl