[postgis-users] PostGIS 3.4 on PG 16 observations

[Gandalf the Gray]

Hi

I have made the following observations regarding PostGIS 3.4 on PG 16 using the archives on buildbot for Winnie.

PostGIS proper works perfectly.

PgRouting does not appear in the list of extensions while using PGAdmin, although it is installable using the command line.

H3_postgis is not installable at all, and gives me the following error:

could not access file "h3_postgis": No such file or directory

H3 is however , installable.

Regards

Pieter

[Gandalf the Gray]

Hi

Sorry, I also meant to ask what is the purpose of the extra info when one does a select postgis_full_version(), like NETWORK_ENABLED=OFF, URL_ENDPOINT, USER_WRITEABLE_DIRECTORY?  DATABASE_PATH I get.  Or should I ask postgres mailing list?

Pieter

[Regina Obe]

It’s a PostGIS/Proj invention.

The reason is ST_Transform behaves differently with some transformations or doesn’t work at all of those settings for network enabled off.  I haven’t tried turning network on on windows and just realized I don’t think I’m packaging the proj.ini or some such thing you can use to control that.

 

The Database Path we also put in because on systems with multiple proj.db present, it’s hard to tell if the proj your postgis was compiled with is using the right database and sometimes proj db changes across major versions of proj.

 

I guess I should add to the release annoucement explaining those.

 

USER_WRITABLE_DIRECTORY is where proj writes grid shift files if it pulls from the internet.

 

Thanks,

Regina

[Regina Obe]

Command line.  You mean CREATE EXTENSION?  Just making sure.  I see it in my extension drop down but could be a refresh issue or something I’m missing cause I’m using a slightly earlier build.

 

H3_postgis ah yes I get the same error.  I’ll let you know once fixed.

 

Thanks,

Regina

 

From: postgis-users [mailto:postgis-us...@lists.osgeo.org] On Behalf Of Gandalf the Gray

Sent: Monday, August 14, 2023 6:57 AM
To: PostGIS Users Discussion <postgi...@lists.osgeo.org>

[Gandalf the Gray]

Hi,

Yes, I mean CREATE EXTENSION

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[Regina Obe]

The h3_postgis issue should be fixed now.  Note that it is now a tagged build instead of using the main repo.

 

https://winnie.postgis.net/download/windows/pg16/buildbot/extras/h3-pg_pg16-binaries-v4.1.3w64.zip

 

Thanks for testing,

[Gandalf the Gray]

Working now, thank you Regina