Re: Resurrecting pg_upgrade

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