Re: ALTER EXTENSION UPGRADE, v3

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Florian Pflug <fgp@phlo.org>, Dimitri Fontaine <dimitri@2ndQuadrant.fr>, "Ross J. Reedstrom" <reedstrm@rice.edu>, Anssi Kääriäinen <anssi.kaariainen@thl.fi>, Itagaki Takahiro <itagaki.takahiro@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2011-02-03T18:10:12Z

Lists: pgsql-hackers

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 currently jumps from PostGIS 1.4 to 1.5.

Best,

David