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.b...@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@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users -- Darafei Praliaskouski Support me: http://patreon.com/komzpa
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
