Re: Resurrecting pg_upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resurrecting pg_upgrade
Date
Msg-id 5775.1071460627@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resurrecting pg_upgrade  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Resurrecting pg_upgrade  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Resurrecting pg_upgrade
Next
From: Tom Lane
Date:
Subject: Re: Resurrecting pg_upgrade