[postgis-tickets] [PostGIS] #3683: Unable to update postgis after postgres pg_upgrade going from < 9.5 to pg > 9.4

[PostGIS]

#3683: Unable to update postgis after postgres pg_upgrade going from < 9.5 to pg >
9.4
-------------------------+-------------------------------------------------
  Reporter:  gregburek   |      Owner:  robe
      Type:  defect      |     Status:  closed
  Priority:  blocker     |  Milestone:  PostGIS 2.3.2
 Component:              |    Version:  2.3.x
  build/upgrade/install  |   Keywords:  pg_upgrade extension update
Resolution:  fixed       |  lifecycle
-------------------------+-------------------------------------------------
Changes (by robe):

 * cc: gregburek (added)


Comment:

 Greg,

 When you get a chance, can you test this out.

 I tested by

 Installing PostGIS 2.3.2dev on PostgreSQL 9.4 server (this ends up not
 including the new brin operators).


 {{{
 CREATE EXTENSION postgis VERSION "2.3.2dev";
 }}}


 Then used pg_upgrade to migrate this to PostgreSQL 9.6.1

 Once up, I ran:


 {{{
 ALTER EXTENSION postgis UPDATE TO "2.3.2devnext";
 }}}


 I verified after running the update step that I now have the brin
 operators, classes, and families.

 Since I'm not using any new constructs, I expect it to work for PostgreSQL
 9.2+

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3683#comment:6>
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.