On Feb 3, 2011, at 10:07 AM, Tom Lane wrote:
> Well, pg_upgrade is designed to work within a major-version series, eg
> you could do a 9.1-to-9.1 upgrade if you needed to install a newer
> version of an extension. Admittedly, this is swinging a rather larger
> hammer than "apply an upgrade script" would entail.
Dude. That's a frigging piledriver!
> But I'm still not
> convinced that we need to expend a great deal of work on making that
> process a tad more efficient.
Agreed. I would handle simple extension upgrades not with pg_upgrade, but the same way I do now. Think about how one
currentlyjumps from PostGIS 1.4 to 1.5.
Best,
David