Re: Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB

David Wall <d.wall@computer.org> writes:
> Is there any reason why the vacuumlo 
> under 7.3 didn't remove large objects that were then removed under 8.0?

[ digs in CVS logs ... ]  I think vacuumlo is actually entirely broken
in the 7.3 branch, because this 7.4 patch:

2002-12-09 20:57  momjian
* contrib/vacuumlo/vacuumlo.c: Following patch avoids removing oidsin the temporary table from the temporary
table.KenjiSugita
 

wasn't ever back-patched.  The former coding was assuming that temp
tables had real names of the form "pg_temp_NNN", which is no longer
true in 7.3, and the net result would be that nothing got deleted.
There were some schema-awareness bugs too, but that one would render
the whole thing a no-op.
        regards, tom lane