Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> 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
