[postgis-tickets] [PostGIS] #5092: Stop filling up the disk with upgrade scripts

[PostGIS]

#5092: Stop filling up the disk with upgrade scripts
------------------------------------+--------------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  enhancement            |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS PostgreSQL
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+--------------------------------
Comment (by Sandro Santilli <strk@…>):

 In [changeset:"984383dc79ffdc185356a37db9b6bc283f7b4c2c/git" 984383d/git]:
 {{{#!CommitTicketReference repository="git"
 revision="984383dc79ffdc185356a37db9b6bc283f7b4c2c"
 Refactor extension upgrade mechanism

 Install <version>--ANY upgrade paths

 These <extension>--<version>--ANY.sql upgrade files will be symlinks
 ( or copies, on systems not supporting symlinks ) to an empty upgrade
 template file named <extension>--TEMPLATED--TO--ANY.sql and be
 overwritten by any future versions of PostGIS, keeping the overall
 number of upgrade paths down ( see #5092 )

 Presence of these upgrade paths will allow ALTER EXTENSION going
 from any version to any other version by stepping by the fake "ANY"
 version. This allows us to stop updating pg_extension table,
 fixing #5194 in a more generic way.

 Stop installing the "<version>--<version>next" and
 "<version>next--<version>" as the same thing can be done by stepping
 by the "ANY" version. Update run_test.pl script accordingly to use
 ANY instead of "next" for self-upgrading newer PostGIS

 Add support for installing missing upgrade paths in the `postgis`
 commandline, to allow upgrading from newly-released stable branches
 to previously-released feature branches.

 Include NEWS entries
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5092#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.