'[postgis-users] Postgis Upgrade/Installation Issues'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Postgis Upgrade/Installation Issues
From:       Roland Che <cheroland89 () outlook ! com>
Date:       2023-09-18 13:04:53
Message-ID: BLAPR07MB7652A9A1F6CE4DB96BE6A99AA9FBA () BLAPR07MB7652 ! namprd07 ! prod ! outlook ! com
[Download RAW message or body]

Hello all
  i am trying to upgrade postgis and postgres from postgres 9.6 to 14 and postgis 2.3 \
to 3.x86_64

  so postgis was installed as sql install on our databases not as an extension .
  i followed this doc to run upgrade scripts and change from sql install to an \
extension based but it did not work  \
https://postgis.net/docs/manual-2.4/postgis_installation.html#make_install_postgis_extensions

  Then got advise to install postgis 3.0 on postgres 9.6 and run some sql scripts and \
do a sql upgrade  but having issues when i try installing postgis 3.0 for postgres \
9.6. Like here  https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script

  ERROR:

  yum install postgis30_96

 Error downloading packages:
  postgis30_96-3.0.4-1.rhel7.x86_64: [Errno 256] No more mirrors to try.

  And when i do download from source code, running the ./configure will give same \
error

  curl -O https://download.osgeo.org/postgis/source/postgis-3.0.0.tar.gz
tar xfz postgis-3.0.0.tar.gz
cd postgis-3.0.0

./configure --with-pgconfig=/usr/pgsql-9.6/bin/pg_config

So this same error occurs also when i used the PGDG archived repo to install postgres \
10 and i am still getting same error.

Please advise on what i can do to solve this.

Regards
Roland Che.

[Attachment #3 (text/html)]

<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"> &nbsp;Hello all
<div class="ContentPasted0">&nbsp; 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">&nbsp; </div> <div class="ContentPasted0">&nbsp; so postgis \
was installed as sql install on our databases not as an extension .</div> <div \
class="ContentPasted0">&nbsp; 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">&nbsp; \
https://postgis.net/docs/manual-2.4/postgis_installation.html#make_install_postgis_extensions</div>
 <div class="ContentPasted0">&nbsp; </div>
<div class="ContentPasted0">&nbsp; 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">&nbsp; but having issues when i try installing postgis 3.0 for \
postgres 9.6. Like here </div>
<div class="ContentPasted0">&nbsp; \
https://postgis.net/docs/postgis_administration.html#soft_upgrade_sql_script</div> \
<div class="ContentPasted0">&nbsp; </div> <div class="ContentPasted0">&nbsp; \
ERROR:</div> <div class="ContentPasted0">&nbsp; </div>
<div class="ContentPasted0">&nbsp; yum install postgis30_96 </div>
<div class="ContentPasted0">&nbsp;</div>
<div class="ContentPasted0">&nbsp;Error downloading packages:</div>
<div class="ContentPasted0">&nbsp; postgis30_96-3.0.4-1.rhel7.x86_64: [Errno 256] No \
more mirrors to try.</div> <div class="ContentPasted0">&nbsp; </div>
<div class="ContentPasted0">&nbsp; And when i do download from source code, running \
the ./configure will give same error</div> <div class="ContentPasted0">&nbsp; </div>
<div class="ContentPasted0">&nbsp; 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>

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

--===============7054202346194558122==--

[prev in list] [next in list] [prev in thread] [next in thread] 