[postgis-users] Help installing h3 extension on postgres 11 with postgis 3.3

[Regina Obe]

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:postgis-users-bounces at lists.osgeo.org] On Behalf Of Claire Palmer
Sent: Friday, March 17, 2023 1:27 PM
To: postgis-users at lists.osgeo.org
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230317/1e0c58ad/attachment.htm>