[postgis-users] postgis upgrade issue (PGSQL="94" (procs need upgrade for use with "96"))

[Thor Bach]

I am trying to upgrade a large postgres 9.6.6 database (10TB+) from postgis
2.4.1 to 2.5.3.
postgresql and all extensions have been built from source.
Several years ago the same database had been upgraded from postgresql 9.4.x
to postgresql 9.6.6 and postgis 2.3.x to postgis 2.4.1
When I run the 'ALTER EXTENSION postgis UPDATE TO "2.5.3";' command, I am
getting the following error:

ERROR:  operator does not exist: gidx public.&& geography
LINE 1: SELECT $2 OPERATOR(public.&&) $1;
                  ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.
QUERY:  SELECT $2 OPERATOR(public.&&) $1;

and when I run 'select postgis_full_version();', I get the following output:

POSTGIS="2.4.1 r16012" PGSQL="94" (procs need upgrade for use with "96")
GEOS="3.7.2-CAPI-1.11.2 b55d2125" PROJ="Rel. 4.9.3, 15 August 2016"
GDAL="GDAL 2.2.2, released 2017/09/15" LIBXML="2.9.4
" LIBJSON="0.12.1" RASTER

Obviously the ' PGSQL="94" (procs need upgrade for use with "96") ' part
indicates a problem. The database has run without any issues for several
years, but I assume the postgis upgrade fails because of the underlying
condition that causes the ' PGSQL="94" ' message.

Does  anybody know what is the fastest way to get the current postgis
configuration into a good state so that the postgis upgrade can be
completed without errors?

Kind Regards

THOR
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191114/c1e901f0/attachment.html>