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

[Darafei "Komяpa" Praliaskouski]

Try the next dance:

alter extension postgis update to "2.4.1next";
alter extension postgis update to "2.4.1";
alter extension postgis update to "3.0.0";

On Thu, Nov 14, 2019 at 4:57 PM Thor Bach <thor.bach at streetlightdata.com>
wrote:

> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191114/e5fac0fd/attachment.html>