Re: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

2024-11-15 Thread Sandro Santilli
On Fri, Nov 15, 2024 at 12:21:25PM +, Anthony DeBarros wrote: > ERROR: extension "postgis" has no update path from version "3.5.0alpha2" to > version "ANY" Try running this on your shell: postgis install-extension-upgrade 3.5.0alpha2 --strk;

Re: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

2024-11-15 Thread Anthony DeBarros
Thanks! Worked like a charm. I think the makers of Postgres App included the alpha version in a beta of 17 at some point. On Nov 15, 2024 at 10:36:30 AM, Regina Obe wrote: > Not sure how you ended up with an alpha2, I had removed that in the final > release thinking no one would be running

RE: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

2024-11-15 Thread Regina Obe
Not sure how you ended up with an alpha2, I had removed that in the final release thinking no one would be running with that that wasn’t building there own. To fix: UPDATE pg_extension SET extversion = 'ANY' where extname LIKE 'postgis%'; And then run the process again. From: Ant

Re: raster2pgsql install

2024-11-15 Thread Gandalf the Gray
Hi Paolo https://winnie.postgis.net/download/windows/pg17/buildbot/postgis-bundle-pg17-3.5.0x64.zip (If you are using PG 17) QGIS Plugin is Called PostGIS Raster Import (for that you have to have PG and PostGIS installed) On Fri, Nov 15, 2024 at 3:02 PM Paolo Cavallini wrote: > Hi, > do you me

Re: raster2pgsql install

2024-11-15 Thread Paolo Cavallini via postgis-users
Hi, do you mean unpacking the installer and extracting the exe? How about the dependencies? Which qgis plugin you mean? Thanks. Il 15 novembre 2024 10:18:01 GMT-01:00, Gandalf the Gray ha scritto: >Hi Paolo > >Get the zip file of PostGIS. > >Or, I use the QGIS plugin > >On Fri, Nov 15, 2024 at

Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

2024-11-15 Thread Anthony DeBarros
Hi, folks, I am running PostgresApp on a Mac and recently updated it to PostgreSQL version 17.1. While running SELECT postgis_extensions_upgrade(); I get the following error: NOTICE: Updating extension postgis 3.5.0alpha2 ERROR: extension "postgis" has no update path from version "3.5.0alpha2

Re: raster2pgsql install

2024-11-15 Thread Gandalf the Gray
Hi Paolo Get the zip file of PostGIS. Or, I use the QGIS plugin On Fri, Nov 15, 2024 at 12:25 PM Paolo Cavallini via postgis-users < postgis-users@lists.osgeo.org> wrote: > Hi all. > Is there a way to install raster2pgsql on windows without the full > PG+postgis stack? > If not, what is the sug

raster2pgsql install

2024-11-15 Thread Paolo Cavallini via postgis-users
Hi all. Is there a way to install raster2pgsql on windows without the full PG+postgis stack? If not, what is the suggested way to import rasters from clients? Thanks.