Re: Resurrecting pg_upgrade

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Resurrecting pg_upgrade
Дата
Msg-id 5775.1071460627@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Resurrecting pg_upgrade  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: Resurrecting pg_upgrade  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Oh, okay, it doesn't work.

> Do you mean using pg_dump with the '-b' option?

Yeah.  Don't you think that should preserve comments on large objects,
now that such comments are alleged to be a supported facility?

> How does pg_dump dump the blobs?

It dumps them, reloads them (which causes them to be assigned new OIDs)
and then runs around and tries to fix up references to them to have the
correct OIDs.  Possibly that last pass could be extended to include
pg_description.  Not sure of details though.
        regards, tom lane


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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Resurrecting pg_upgrade
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Resurrecting pg_upgrade