| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Greg Stark <gsstark(at)mit(dot)edu>, decibel <decibel(at)decibel(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Page-level version upgrade (was: Block-level CRC checks) |
| Date: | 2009-12-02 19:27:40 |
| Message-ID: | 4B16BFAC.4010704@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas wrote:
> On Wed, Dec 2, 2009 at 1:56 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
>
>> There's no reason the associated catalog support had to ship with the old
>> version. You can always modify the catalog after initdb, but before running
>> the pre-upgrade utility. pg_migrator might make that change for you.
>>
>
> Uh, really? I don't think that's possible at all.
>
Worst case just to get this bootstrapped: you install a new table with
the added bits. Old version page upgrader accounts for itself there.
pg_migrator dumps that data and then loads it into its new, correct home
on the newer version. There's already stuff like that being done
anyway--dumping things from the old catalog and inserting into the new
one--and if the origin is actually an add-on rather than an original
catalog page it doesn't really matter. As long as the new version can
see the info it needs in its catalog it doesn't matter how it got to
there; that's the one that needs to check the migration status before it
can access things outside of the catalog.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Mansion | 2009-12-02 19:45:44 | Re: Patch: Remove gcc dependency in definition of inline functions |
| Previous Message | Robert Haas | 2009-12-02 19:04:17 | Re: Page-level version upgrade (was: Block-level CRC checks) |