Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump: dumpBlobs(): error reading large object: ERROR: - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump: dumpBlobs(): error reading large object: ERROR:
Date
Msg-id 5791.1058466750@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump: dumpBlobs(): error reading large object: ERROR:  (Sergio Pili <sergio.pili@spm.com.ar>)
Responses Re: pg_dump: dumpBlobs(): error reading large object: ERROR:  (Dani Oderbolz <oderbolz@ecologic.de>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Arrays in pl/pgsql functions
Next
From: Charles Haron
Date:
Subject: Adding PL/Perl