I package the windows postgis EDB extensions.
Looking at my PostgreSQL 11, I’m not seeing any issue. I can do CREATE EXTENSION h3; CREATE EXTENSION h3_postgis; Can you confirm those don’t work if you do it manually in your database? It might be something wrong with the create spatial database option. I recall I had issue with packaging h3 for PG 11 because they had introduced a syntax in h3 (ALTER AGGREGATE ..) which came in PostgreSQL 12 and so didn’t work in PG 11. I reported it and they fixed the issue, and I had to repackage PG11. Something might have gone wrong or maybe somehow you ended up with an earlier package. If you still have issue, I can check on my end installing on a clean PG11 to make sure the latest package works. Thanks, Regina From: postgis-users [mailto:[email protected]] On Behalf Of Claire Palmer Sent: Friday, March 17, 2023 1:27 PM To: [email protected] Subject: [postgis-users] Help installing h3 extension on postgres 11 with postgis 3.3 Hi postgis-users, Has anyone run into problems installing the h3 extension on postgres11 Windows? I ran the EDB Stack Builder to upgrade postgis from 3.2 to 3.3 and all went well, except the "create spatial database" option failed with: "Error: could not access file "h3": No such file or directory" I checked the Postgres files on C: and h3.dll exists in \lib and h3.control, h3_postgis.control exists in \share\extension. So I'm not sure what 'no such file or directory' means. I have postgres14 on another Windows machine, and I was able to install h3 and h3_postgis extensions without any problems. So maybe the issue is with postgres11? Normally I would just move on with the h3 on postgres14; however the postgres11 server houses our core databases, so I'm really looking to have h3 enabled on them. The output for postgis_full_version(): POSTGIS="3.3.2 3.3.2" [EXTENSION] PGSQL="110" GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1" GDAL="GDAL 3.4.3, released 2022/04/22" LIBXML="2.9.9" LIBJSON="0.12" LIBROTOBUF="1.2.1" WAGYU=0.5.0 (Internal)" RASTER Any suggestions would be appreciated! Many thanks, Claire
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
