Re: pg_upgrade (was: 8.2 features status) - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: pg_upgrade (was: 8.2 features status)
Date
Msg-id 20060804181216.GI20016@kenobi.snowman.net
Whole thread Raw
In response to pg_upgrade (was: 8.2 features status)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: pg_upgrade (was: 8.2 features status)
List pgsql-hackers
* Jim C. Nasby (jnasby@pervasive.com) wrote:
> On Thu, Aug 03, 2006 at 11:20:48PM -0700, Josh Berkus wrote:
> > > * In-place upgrades (pg_upgrade)
> >
> > BTW, I may get Sun to contribute an engineer for this; will get you posted.
>
> How would such a thing handle changes to page formats?

Couldn't this be done by converting a table/partial-table at a time?
It wouldn't be something which could run while the system is live, but
it'd probably take less time than dump/restore and wouldn't require
double the disk space of the whole database... no?
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: mdean
Date:
Subject: Re: 8.2 features status
Next
From: Tom Lane
Date:
Subject: "Constraint exclusion" is not general enough