<html><head></head><body><div class="ydp533c38b7yahoo-style-wrap" style="font-family:times new roman, new york, times, serif;font-size:16px;"><div><div><div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">Hello Everyone,</div><div dir="ltr" style="font-family: times new roman, new york, times, serif; font-size: 16px;">we am trying to upgrade postgresql9.6 to postgresql 14 and postgis with below steps following</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">the postgis compartibility with postgis.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">postgres 9.6( postgis 2.3) -> postgres 10 ( postgis 2.3) ( postgres upgrade)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">postgres 10 (postgis 2.3) -> postgres 10 (postgis 2.5) ( postgis upgrade)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">postgres 10 ( postgis 2.5) -> postgres 11 ( postgis 2.5) ( postgres upgrade)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">postgres 11 ( postgis 2.5) -> postgres 11 ( postgis 3.1) ( postgis upgrade)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">postgres 11 ( postgis 3.1) -> postgres 14 ( postgis 3.1) ( postgres upgrade)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">So what i have done so far is .</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">1) First i have upgrade postgres 9.6 with postgis 2.3 to postgres 10 with same postgis 2.3.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> i installed postgres 10 and installed postgres contrib, then for postgis, i copied the postgis</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> libraries from postgres 9.6 to postgres 10 and also installed "yum install postgis23_10"</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> and i think its the compartible postgis 2.3 for version 10 i installed made the pg_upgrade successful</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> and as postgres 9.6 and 10 postgis functions are compartible.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> >>>>>>So from postgres 9.6 to 10, i was able to run pg_upgrade successfully.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> </div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">2) Upgrading from postgres 10 to postgres 11 but have to upgrade postgis 2.3 to postgis 2.5 as those are compartible.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">So far postgres 10 already has postgis23_10 installed as i did when i wanted to upgrade from 9.6 to 10.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">So i went ahead and installed "yum install postgresql11-contrib and yum install postgis25_11" so as to see if i can</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">have an upgrade path from postgis 2.3 to 2.5 as postgres 11 is compartible with postgis 2.5.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">Upgrade of Postgis will fail and reading from postgis website i see not all can be upgraded using the alter command.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">\dx that list entensions will not bring up postgis.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxx=# \dx</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> List of installed extensions</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> Name | Version | Schema | Description </div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">--------------------+---------+------------+--------------------------------------------------------------</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> hstore | 1.4 | public | data type for storing sets of (key, value) pairs</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> pg_repack | 1.4.6 | public | Reorganize tables in PostgreSQL databases with minimal locks</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> pgcrypto | 1.3 | public | cryptographic functions</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> pgstattuple | 1.5 | public | show tuple-level statistics</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">(7 rows)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxx=# SELECT postgis_full_version();</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">NOTICE: Function postgis_gdal_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">NOTICE: Function postgis_raster_scripts_installed() not found. Is raster support enabled and rtpostgis.sql installed?</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">NOTICE: Function postgis_raster_lib_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> postgis_full_version </div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">---------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> 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)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">(1 row)</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxx=# SELECT postgis_extensions_upgrade();</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">ERROR: function postgis_extensions_upgrade() does not exist</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">LINE 1: SELECT postgis_extensions_upgrade();</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> ^</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">ERROR: extension "postgis" does not exist</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5';</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">ERROR: extension "postgis" does not exist</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">xxxxxx=# ALTER EXTENSION postgis UPDATE;</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">ERROR: extension "postgis" does not exist</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">PLEASE CAN SOMEONE ASSIST TO EXPLAIN MY OPTIONS TO UPGRADE POSTGIS?</div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;"><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 16px;">THANKS ALL. </div></div><br></div><div><br></div><div class="ydp533c38b7signature"><div style="font-family:new times, serif;font-size:16px;"><font face="lucida console, sans-serif"><font style="font-size:16px;">--------------------------------------------<font color="#ffffff">- </font></font></font><div dir="ltr">Marcelius Atanga</div><div dir="ltr">Tel: +13025384841</div><span style="font-family:serif;font-size:16px;background-color:rgb(255, 255, 255);"><font color="#5b8828" style="background-color: inherit;"><br><span style="font-family:serif;font-weight:bold;font-size:small;"> </span></font><span style="font-family:serif;font-size:small;color:rgb(112, 172, 237);"> <br></span></span><div style="display:none;" id="ydp4fbbcc0skype_c2c_menu_container" class="ydp4fbbcc0skype_c2c_menu_container ydp4fbbcc0notranslate"><div class="ydp4fbbcc0skype_c2c_menu_click2call"><a id="ydp4fbbcc0skype_c2c_menu_click2call_action" class="ydp4fbbcc0skype_c2c_menu_click2call_action">Call</a></div><div class="ydp4fbbcc0skype_c2c_menu_click2sms"><a id="ydp4fbbcc0skype_c2c_menu_click2sms_action" class="ydp4fbbcc0skype_c2c_menu_click2sms_action">Send SMS</a></div><div class="ydp4fbbcc0skype_c2c_menu_push_to_mobile"><a id="ydp4fbbcc0skype_c2c_menu_push_to_mobile_action" class="ydp4fbbcc0skype_c2c_menu_push_to_mobile_action">Call from mobile</a></div><div class="ydp4fbbcc0skype_c2c_menu_add2skype"><a id="ydp4fbbcc0skype_c2c_menu_add2skype_text" class="ydp4fbbcc0skype_c2c_menu_add2skype_text">Add to Skype</a></div><div class="ydp4fbbcc0skype_c2c_menu_toll_info"><span class="ydp4fbbcc0skype_c2c_menu_toll_callcredit">You'll need Skype Credit</span><span class="ydp4fbbcc0skype_c2c_menu_toll_free">Free via Skype</span></div></div></div></div></div>
<div><br></div><div><br></div>
</div><div id="yahoo_quoted_3726498548" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, August 16, 2023 at 07:55:09 AM EDT, atanga MARCELIUS <marx407@yahoo.ca> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv3641889896"><div><div style="font-family:times new roman, new york, times, serif;font-size:16px;" class="yiv3641889896ydp1f2abebayahoo-style-wrap"><div><div dir="ltr"><div><div>Hello Everyone,</div><div dir="ltr">we am trying to upgrade postgresql9.6 to postgresql 14 and postgis with below steps following</div><div>the postgis compartibility with postgis.</div><div><br></div><div>postgres 9.6( postgis 2.3) -> postgres 10 ( postgis 2.3) ( postgres upgrade)</div><div><br></div><div>postgres 10 (postgis 2.3) -> postgres 10 (postgis 2.5) ( postgis upgrade)</div><div><br></div><div>postgres 10 ( postgis 2.5) -> postgres 11 ( postgis 2.5) ( postgres upgrade)</div><div><br></div><div>postgres 11 ( postgis 2.5) -> postgres 11 ( postgis 3.1) ( postgis upgrade)</div><div><br></div><div>postgres 11 ( postgis 3.1) -> postgres 14 ( postgis 3.1) ( postgres upgrade)</div><div><br></div><div><br></div><div>So what i have done so far is .</div><div><br></div><div>1) First i have upgrade postgres 9.6 with postgis 2.3 to postgres 10 with same postgis 2.3.</div><div> i installed postgres 10 and installed postgres contrib, then for postgis, i copied the postgis</div><div> libraries from postgres 9.6 to postgres 10 and also installed "yum install postgis23_10"</div><div> and i think its the compartible postgis 2.3 for version 10 i installed made the pg_upgrade successful</div><div> and as postgres 9.6 and 10 postgis functions are compartible.</div><div> >>>>>>So from postgres 9.6 to 10, i was able to run pg_upgrade successfully.</div><div> </div><div>2) Upgrading from postgres 10 to postgres 11 but have to upgrade postgis 2.3 to postgis 2.5 as those are compartible.</div><div><br></div><div>So far postgres 10 already has postgis23_10 installed as i did when i wanted to upgrade from 9.6 to 10.</div><div>So i went ahead and installed "yum install postgresql11-contrib and yum install postgis25_11" so as to see if i can</div><div>have an upgrade path from postgis 2.3 to 2.5 as postgres 11 is compartible with postgis 2.5.</div><div><br></div><div>Upgrade of Postgis will fail and reading from postgis website i see not all can be upgraded using the alter command.</div><div><br></div><div>\dx that list entensions will not bring up postgis.</div><div><br></div><div>xxxxx=# \dx</div><div> List of installed extensions</div><div> Name | Version | Schema | Description </div><div>--------------------+---------+------------+--------------------------------------------------------------</div><div> hstore | 1.4 | public | data type for storing sets of (key, value) pairs</div><div> pg_repack | 1.4.6 | public | Reorganize tables in PostgreSQL databases with minimal locks</div><div> pg_stat_statements | 1.6 | public | track execution statistics of all SQL statements executed</div><div> pgcrypto | 1.3 | public | cryptographic functions</div><div> pgstattuple | 1.5 | public | show tuple-level statistics</div><div> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language</div><div> uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs)</div><div>(7 rows)</div><div><br></div><div><br></div><div>xxxxx=# SELECT postgis_full_version();</div><div>NOTICE: Function postgis_gdal_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div>NOTICE: Function postgis_raster_scripts_installed() not found. Is raster support enabled and rtpostgis.sql installed?</div><div>NOTICE: Function postgis_raster_lib_version() not found. Is raster support enabled and rtpostgis.sql installed?</div><div> postgis_full_version </div><div>---------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div> 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)</div><div>(1 row)</div><div><br></div><div><br></div><div>xxxxx=# SELECT postgis_extensions_upgrade();</div><div>ERROR: function postgis_extensions_upgrade() does not exist</div><div>LINE 1: SELECT postgis_extensions_upgrade();</div><div> ^</div><div>HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div><div><br></div><div><br></div><div>xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5.5';</div><div>ERROR: extension "postgis" does not exist</div><div>xxxxx=# ALTER EXTENSION postgis UPDATE TO '2.5';</div><div>ERROR: extension "postgis" does not exist</div><div>xxxxxx=# ALTER EXTENSION postgis UPDATE;</div><div>ERROR: extension "postgis" does not exist</div><div><br></div><div><br></div><div>PLEASE CAN SOMEONE ASSIST TO EXPLAIN MY OPTIONS TO UPGRADE POSTGIS?</div><div><br></div><div>THANKS ALL. </div></div><br></div><div><br></div><div class="yiv3641889896ydp1f2abebasignature"><div style="font-family:new times, serif;font-size:16px;"><font face="lucida console, sans-serif"><font style="font-size:16px;">--------------------------------------------<font color="#ffffff">- </font></font></font><div dir="ltr">Marcelius Atanga</div><div dir="ltr">Tel: +13025384841</div><span style="font-family:serif;font-size:16px;background-color:rgb(255, 255, 255);"><font color="#5b8828" style="background-color:inherit;"><br><span style="font-family:serif;font-weight:bold;font-size:small;"> </span></font><span style="font-family:serif;font-size:small;color:rgb(112, 172, 237);"> <br></span></span><div style="display:none;" id="yiv3641889896ydp4fbbcc0skype_c2c_menu_container" class="yiv3641889896ydp4fbbcc0skype_c2c_menu_container yiv3641889896ydp4fbbcc0notranslate"><div class="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2call"><a rel="nofollow noopener noreferrer" id="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2call_action" class="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2call_action">Call</a></div><div class="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2sms"><a rel="nofollow noopener noreferrer" id="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2sms_action" class="yiv3641889896ydp4fbbcc0skype_c2c_menu_click2sms_action">Send SMS</a></div><div class="yiv3641889896ydp4fbbcc0skype_c2c_menu_push_to_mobile"><a rel="nofollow noopener noreferrer" id="yiv3641889896ydp4fbbcc0skype_c2c_menu_push_to_mobile_action" class="yiv3641889896ydp4fbbcc0skype_c2c_menu_push_to_mobile_action">Call from mobile</a></div><div class="yiv3641889896ydp4fbbcc0skype_c2c_menu_add2skype"><a rel="nofollow noopener noreferrer" id="yiv3641889896ydp4fbbcc0skype_c2c_menu_add2skype_text" class="yiv3641889896ydp4fbbcc0skype_c2c_menu_add2skype_text">Add to Skype</a></div><div class="yiv3641889896ydp4fbbcc0skype_c2c_menu_toll_info"><span class="yiv3641889896ydp4fbbcc0skype_c2c_menu_toll_callcredit">You'll need Skype Credit</span><span class="yiv3641889896ydp4fbbcc0skype_c2c_menu_toll_free">Free via Skype</span></div></div></div></div></div></div></div></div></div>
</div>
</div></body></html>