[postgis-users] Help with Upgrade using YUM

Sun Aug 20 13:34:12 PDT 2023

Atanga,

Please DO NOT EVER reply back to an unrelated question of your issue.  It just derails the conversation and is bad etiquette for any list.

Not only that but you annoyed other people in other lists since this was sent to more than PostGIS users.

I’ve changed the subject so as not to confuse people. 

Your best bet is to symlink or copy  the new .so files to the old name as I have described here:

https://www.bostongis.com/blog/index.php?/archives/273-Using-pg_upgrade-to-upgrade-PostgreSQL-9.3-PostGIS-2.1-to-PostgreSQL-11-2.5-on-Yum.html

Hope that helps,

Regina

From: atanga MARCELIUS [mailto:marx407 at yahoo.ca] 
Sent: Sunday, August 20, 2023 8:49 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>; Regina Obe <lr at pcorp.us>
Cc: 'PostGIS Development Discussion' <postgis-devel at lists.osgeo.org>; 'pgRouting users mailing list' <pgrouting-users at lists.osgeo.org>; 'pgRouting developers mailing list' <pgrouting-dev at lists.osgeo.org>; mobilitydb-users at lists.osgeo.org
Subject: Re: [postgis-users] PostGIS 3.4.0 binaries and Installers for Windows PostgreSQL 12-16

Hello Everyone,

we am trying to upgrade postgresql9.6 to postgresql 14 and postgis with below steps following

the postgis compartibility with postgis.

postgres 9.6( postgis 2.3) -> postgres 10 ( postgis 2.3) ( postgres upgrade)

postgres 10 (postgis 2.3) -> postgres 10 (postgis 2.5) ( postgis upgrade)

postgres 10 ( postgis 2.5) -> postgres 11 ( postgis 2.5) ( postgres upgrade)

postgres 11 ( postgis 2.5) -> postgres 11 ( postgis 3.1) ( postgis upgrade)

postgres 11 ( postgis 3.1) -> postgres 14 ( postgis 3.1) ( postgres upgrade)

So what i have done so far is .

1) First i have upgrade postgres 9.6 with postgis 2.3 to postgres 10 with same postgis 2.3.

 i installed postgres 10 and installed postgres contrib, then for postgis, i copied the postgis

 libraries from postgres 9.6 to postgres 10 and also installed "yum install postgis23_10"

 and i think its the compartible postgis 2.3 for version 10 i installed made the pg_upgrade successful

 and as postgres 9.6 and 10 postgis functions are compartible.

 >>>>>>So from postgres 9.6 to 10, i was able to run pg_upgrade successfully.

2) Upgrading from postgres 10 to postgres 11 but have to upgrade postgis 2.3 to postgis 2.5 as those are compartible.

So far postgres 10 already has postgis23_10 installed as i did when i wanted to upgrade from 9.6 to 10.

So i went ahead and installed "yum install postgresql11-contrib and yum install postgis25_11" so as to see if i can

have an upgrade path from postgis 2.3 to 2.5 as postgres 11 is compartible with postgis 2.5.

Upgrade of Postgis will fail and reading from postgis website i see not all can be upgraded using the alter command.

\dx that list entensions will not bring up postgis.

xxxxx=# \dx

                                       List of installed extensions

        Name | Version | Schema | Description                          

--------------------+---------+------------+--------------------------------------------------------------

 hstore | 1.4 | public | data type for storing sets of (key, value) pairs

 pg_repack | 1.4.6 | public | Reorganize tables in PostgreSQL databases with minimal locks

 pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed

 pgcrypto | 1.3 | public | cryptographic functions

 pgstattuple | 1.5 | public | show tuple-level statistics

 plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

 uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs)

(7 rows)

xxxxx=# SELECT postgis_full_version();

NOTICE: Function postgis_gdal_version() not found. Is raster support enabled and rtpostgis.sql installed?

NOTICE: Function postgis_raster_scripts_installed() not found. Is raster support enabled and rtpostgis.sql installed?

NOTICE: Function postgis_raster_lib_version() not found. Is raster support enabled and rtpostgis.sql installed?

                                                                     postgis_full_version                                                                      

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 POSTGIS="2.3.7 r16523" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.1" LIBJSON="0.11" (core procs from "2.3.2 r15302" need upgrade)

(1 row)

xxxxx=# SELECT postgis_extensions_upgrade();

ERROR: function postgis_extensions_upgrade() does not exist

LINE 1: SELECT postgis_extensions_upgrade();

               ^

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';

ERROR: extension "postgis" does not exist

xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5';

ERROR: extension "postgis" does not exist

xxxxxx=# ALTER EXTENSION postgis UPDATE;

ERROR: extension "postgis" does not exist

PLEASE CAN SOMEONE ASSIST TO EXPLAIN MY OPTIONS TO UPGRADE POSTGIS?

THANKS ALL. 

---------------------------------------------  

Marcelius Atanga

Tel: +13025384841

Sent from Yahoo Mail on Android <https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_EmailSignature&af_sub1=Acquisition&af_sub2=Global_YMktg&af_sub3=&af_sub4=100000604&af_sub5=EmailSignature__Static_> 

On Sat, Aug 19, 2023 at 8:44 PM, Regina Obe

<lr at pcorp.us <mailto:lr at pcorp.us> > wrote:

I've published the installers for PostGIS 3.4.0 bundle for Windows PostgreSQL 12, 13, 14, 15, and 16

Details on this page:                                      

https://postgis.net/documentation/getting_started/install_windows/released_versions/

Extensions included are:

PostGIS 3.4.0 project: postgis, postgis_raster, postgis_topology, postgis_tiger_geocoder, postgis_sfcgal, address_standardizer, address_standardizer_data_us

pgRouting: pgrouting 3.5.0

h3-pg 4.1.3: h3, h3_postgis 

pgpointcloud : 1.2.4 pointcloud, pointcloud_postgis

ogr_fdw: 1.1.4

mobilitydb: 1.1.0alpha

enabling in databases detailed here - https://postgis.net/documentation/getting_started/install_windows/enabling_postgis/

Let me know if you run into any issues.

Thanks,

Regina

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230820/77a32c2d/attachment.htm>