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

[Regina Obe]

Well that error suggests the path it is looking for is not right or a permissions issue?

 

I’d first try reinstalling the postgis package from here on your production server  – 

 

https://download.osgeo.org/postgis/windows/pg11/postgis-bundle-pg11x64-setup-3.3.2-2.exe

 

Then repeat the CREATE EXTENSION h3; in the databases.

 

If you still get the same error, check the permissions on the h3.dll in your C:\Program Files/PostgreSQL/11/lib/h3.dll  and verify it’s the same permissions as the postgis-3.dll in the same folder, which I assume is working.

 

Also make sure you have no virus thing blocking access.

 

 

You can also upgrade your PostgreSQL 11 to the latest.  Just install over your existing, no need to uninstall to upgrade it.

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Claire Palmer
Sent: Friday, March 17, 2023 4:24 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Help installing h3 extension on postgres 11 with postgis 3.3

 

Hi Regina,

 

Yes, when running CREATE EXTENSION h3; manually I get:  ERROR: could not access file "h3": No such file or directory.

With CREATE EXTENSION h3_postgis; I get:  ERROR: required extension "h3" is not installed.

 

I went ahead and installed postgres 11 on my other Windows machine.  The h3 and h3_postgis extensions installed successfully.  So then I checked the version of postgres11 with our core databases (11.14) versus the one I just installed (11.19).  So the issue seems to be with postgres 11.14.

 

I used EDB to install the minor upgrade from 11.14 to 11.19 on the postgres11 with our core databases.  The install went fine, all data is there, select version() now gives 11.19, but CREATE EXTENTION h3 still gives ERROR: could not access file "h3": No such file or directory.

 

I guess the last thing to try is to dump databases to file, wipe current postgres 11, re-install fresh postgres 11 and restore database dumps.  

 

Anyway just reporting on progress as maybe this will help someone else out there.

 

Claire

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