Re: Resurrecting pg_upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Resurrecting pg_upgrade
Date: 2003-12-15 03:57:07
Message-ID: 5775.1071460627@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-15 04:04:04 Re: Resurrecting pg_upgrade
Previous Message Christopher Kings-Lynne 2003-12-15 03:53:44 Re: Resurrecting pg_upgrade