<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Hello all
<div class="ContentPasted0"> i am trying to upgrade postgis and postgres from postgres 9.6 to 14 and postgis 2.3 to 3.x86_64</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> so postgis was installed as sql install on our databases not as an extension .</div>
<div class="ContentPasted0"> i followed this doc to run upgrade scripts and change from sql install to an extension based but it did not work</div>
<div class="ContentPasted0"> https://postgis.net/docs/manual-2.4/postgis_installation.html#make_install_postgis_extensions</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> Then got advise to install postgis 3.0 on postgres 9.6 and run some sql scripts and do a sql upgrade</div>
<div class="ContentPasted0"> but having issues when i try installing postgis 3.0 for postgres 9.6. Like here
</div>
<div class="ContentPasted0"> https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> ERROR:</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> yum install postgis30_96 </div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> Error downloading packages:</div>
<div class="ContentPasted0"> postgis30_96-3.0.4-1.rhel7.x86_64: [Errno 256] No more mirrors to try.</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> And when i do download from source code, running the ./configure will give same error</div>
<div class="ContentPasted0"> </div>
<div class="ContentPasted0"> curl -O https://download.osgeo.org/postgis/source/postgis-3.0.0.tar.gz</div>
<div class="ContentPasted0">tar xfz postgis-3.0.0.tar.gz</div>
<div class="ContentPasted0">cd postgis-3.0.0</div>
<div><br class="ContentPasted0">
</div>
<div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">./configure --with-pgconfig=/usr/pgsql-9.6/bin/pg_config</div>
<div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">So this same error occurs also when i used the PGDG archived repo to install postgres 10</div>
<div class="ContentPasted0">and i am still getting same error.</div>
<div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">Please advise on what i can do to solve this.</div>
<div><br class="ContentPasted0">
</div>
<div class="ContentPasted0">Regards</div>
Roland Che.<br>
</div>
</body>
</html>