[postgis-tickets] [PostGIS] #4685: Error upgrading postGIS from 2.4.4 to 2.5.4 on postgres 10.12

[PostGIS]

#4685: Error upgrading postGIS from 2.4.4 to 2.5.4 on postgres 10.12
-------------------------+---------------------
 Reporter:  sjezewskisf  |      Owner:  pramsey
     Type:  defect       |     Status:  new
 Priority:  medium       |  Milestone:
Component:  postgis      |    Version:  2.5.x
 Keywords:               |
-------------------------+---------------------
 Hi there -

 It seems like there is a regression of this bug:

 https://trac.osgeo.org/postgis/ticket/3683?cversion=0&cnum_hist=1

 I work at Heroku where we offer postgres as a service for millions of
 databases. We offer postGIS support as a beta feature.

 Some customers are experiencing problems upgrading from postgres 10.12
 with postGIS 2.4.4

 The specific error we see is:

 ```
  sql_error_code = 00000 LOG:  statement: ALTER EXTENSION "postgis" UPDATE;
   sql_error_code = 01000 CONTEXT:  SQL statement "SELECT
 postgis_lib_version()"
       PL/pgSQL function postgis_major_version_check() line 21 at SQL
 statement
   sql_error_code = 42883 ERROR:  operator does not exist: gidx public.&&
 geography at character 11
   sql_error_code = 42883 HINT:  No operator matches the given name and
 argument type(s). You might need to add explicit type casts.
   sql_error_code = 42883 QUERY:  SELECT $2 OPERATOR(public.&&) $1;
 ```

 The version of postGIS that its attempting to upgrade to is 2.5.4

 We have many customers using postGIS 2.4.4 and they will be unable to
 upgrade (their PG versions) until this is fixed.

 It seems like we see postGIS upgrading errors from time to time like this.
 Do you all have a test matrix that provides clarity on which versions /
 upgrade paths are supported?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4685>
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.