Re: pg_dumpall 8.1.4 large objects error - Mailing list pgsql-admin

Jeff Frost <jeff@frostconsultingllc.com> writes:
> I'm curious why this would happen:
> pg_dump: dumpBlobs(): could not open large object: ERROR:  inv_open: large
> object 145391 not found

Some cursory trawling in the REL7_3 sources says that this means that
"SELECT DISTINCT loid FROM pg_largeobject" found a large object OID
that then could not be found by an indexscan of pg_largeobject.  So
I'd try a REINDEX of pg_largeobject to see if that fixes it.  See the
REINDEX man page concerning hoops you have to jump through to reindex
a system catalog --- IIRC, the hoops are much higher and narrower back
in 7.3.

> The db being dumped is 7.3.2

Of course, I'm reading 7.3.15 sources ...

            regards, tom lane