Re: [GENERAL] large object does not exist after pg_migrator

2009-07-13 Thread Jamie Fox
Hi - This is probably more helpful - the pg_largeobject table only changed after vacuumlo, not before. When comparing pre- and post- pg_migrator databases (no vacuum or vacuumlo): select * from pg_largeobject where loid = '24696063'; in the pre- there are three rows, having pageno 0 through 3, i

[GENERAL] large object does not exist after pg_migrator

2009-07-13 Thread Jamie Fox
Hi - After what seemed to be a normal successful pg_migrator migration from 8.3.7 to 8.4.0, in either link or copy mode, vacuumlo fails on both our production and qa databases: Jul 1 11:17:03 db2 postgres[9321]: [14-1] LOG: duration: 175.563 ms statement: DELETE FROM vacuum_l WHERE lo IN (SELEC