[postgis-users] Stuck with upgrade from postgresql 9.6 to postgresql 14 due to postgis2.3

[atanga MARCELIUS]

Hello Sandro, Thanks for your support.

 Please here are the out put to the queries you suggested.

I have also attached the output in text document in a clearer format.

My main concern here is how to  manage the upgrade path from postgis 2.3 in postgresql 9.6  to  a compactible version of postgis  in postgresql14  given that postgis 2.3 was hard install(using source code) and given my environmental challenges I do not want to do a dump and restore?

1.
postgres=# SELECT postgis_full_version();                                                                            postgis_full_version                                                                            ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- POSTGIS="2.3.7 r16523" PGSQL="100" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER(1 row)
2.postgres=# SELECT oid::regprocedure,probin  FROM pg_catalog.pg_proc  WHERE proname LIKE 'postgis_%version';             oid              |        probin         ------------------------------+----------------------- postgis_version()            | $libdir/postgis-2.3 postgis_liblwgeom_version()  | $libdir/postgis-2.3 postgis_proj_version()       | $libdir/postgis-2.3 postgis_lib_version()        | $libdir/postgis-2.3 postgis_geos_version()       | $libdir/postgis-2.3 postgis_svn_version()        | $libdir/postgis-2.3 postgis_libxml_version()     | $libdir/postgis-2.3 postgis_full_version()       |  postgis_libjson_version()    | $libdir/postgis-2.3 postgis_raster_lib_version() | $libdir/rtpostgis-2.3 postgis_gdal_version()       | $libdir/rtpostgis-2.3(11 rows)
postgres=# 


---------------------------------------------  Marcelius AtangaTel: +13025384841
                       
CallSend SMSCall from mobileAdd to SkypeYou'll need Skype CreditFree via Skype 

    On Tuesday, August 29, 2023 at 02:55:37 AM EDT, atanga MARCELIUS <marx407 at yahoo.ca> wrote:  
 
 Hello Sandro, Thanks for your support.

 Please here are the out put to the queries you suggested.

I have also attached the output in text document in a clearer format.

My main concern here is how to  manage the upgrade path from postgis 2.3 in postgresql 9.6  to  a compactible version of postgis  in postgresql14  given that postgis 2.3 was hard install(using source code) and given my environmental challenges I do not want to do a dump and restore?

1.
postgres=# SELECT postgis_full_version();                                                                            postgis_full_version                                                                            ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- POSTGIS="2.3.7 r16523" PGSQL="100" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER(1 row)
2.postgres=# SELECT oid::regprocedure,probin  FROM pg_catalog.pg_proc  WHERE proname LIKE 'postgis_%version';             oid              |        probin         ------------------------------+----------------------- postgis_version()            | $libdir/postgis-2.3 postgis_liblwgeom_version()  | $libdir/postgis-2.3 postgis_proj_version()       | $libdir/postgis-2.3 postgis_lib_version()        | $libdir/postgis-2.3 postgis_geos_version()       | $libdir/postgis-2.3 postgis_svn_version()        | $libdir/postgis-2.3 postgis_libxml_version()     | $libdir/postgis-2.3 postgis_full_version()       |  postgis_libjson_version()    | $libdir/postgis-2.3 postgis_raster_lib_version() | $libdir/rtpostgis-2.3 postgis_gdal_version()       | $libdir/rtpostgis-2.3(11 rows)
postgres=# 

---------------------------------------------  Marcelius AtangaTel: +13025384841
                       
CallSend SMSCall from mobileAdd to SkypeYou'll need Skype CreditFree via Skype 

    On Wednesday, August 23, 2023 at 11:31:11 AM EDT, Sandro Santilli <strk at kbt.io> wrote:  
 
 On Wed, Aug 23, 2023 at 10:08:23AM +0000, atanga MARCELIUS wrote:

> xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';
> ERROR:  extension "postgis" does not exist

The above message means that database "xxxxx" does not contain
the "postgis extension". This does not necessarely mean it doesn't
contain postgis objects, if you're coming from a very old install
as you seem to be coming from.

What does this query return?

  SELECT postgis_full_version();

And this one ?

  SELECT oid::regprocedure,probin
  FROM pg_catalog.pg_proc
  WHERE proname LIKE 'postgis_%version';

--strk;

  Libre GIS consultant/developer
  https://strk.kbt.io/services.html
    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230830/44bf0b8f/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: postgis2.3 upgrade.txt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230830/44bf0b8f/attachment.txt>