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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB
Дата
Msg-id 24170.1126555024@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB  (David Wall <d.wall@computer.org>)
Список pgsql-interfaces
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


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: David Wall
Дата:
Сообщение: Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Beta of DBD::Pg 1.44 available