[postgis-users] Postgis Upgrade/Installation Issues

[Roland Che]

 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230918/e852298b/attachment.htm>