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
<marx...@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
<s...@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
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" LIBJS
ON="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=# _______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
