public inbox for [email protected]help / color / mirror / Atom feed
Include h3-pg extension 9+ messages / 3 participants [nested] [flat]
* Include h3-pg extension @ 2023-11-04 02:44 Regina Obe <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Regina Obe @ 2023-11-04 02:44 UTC (permalink / raw) To: [email protected] I couldn't find this when searching, so assume it's not available yet on apt.postgresql.org. H3-pg is an Uber Hexagon Extension commonly used with PostGIS and is growing in popularity. It relies on postgis and postgis_raster extensions. https://github.com/zachasme/h3-pg Would you consider carrying it? Thanks, Regina ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-04 09:50 Christoph Berg <[email protected]> parent: Regina Obe <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Christoph Berg @ 2023-11-04 09:50 UTC (permalink / raw) To: Regina Obe <[email protected]>; +Cc: [email protected] Re: Regina Obe > I couldn't find this when searching, so assume it's not available yet on > apt.postgresql.org. > > H3-pg is an Uber Hexagon Extension commonly used with PostGIS and is growing > in popularity. > > It relies on postgis and postgis_raster extensions. > > https://github.com/zachasme/h3-pg > > Would you consider carrying it? Hi Regina, it looks like https://github.com/uber/h3 hasn't been packaged yet, which makes this a bit more complicated. I'll see if I can find the time to package both. Christoph ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-05 00:37 Devrim Gündüz <[email protected]> parent: Christoph Berg <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Devrim Gündüz @ 2023-11-05 00:37 UTC (permalink / raw) To: Christoph Berg <[email protected]>; Regina Obe <[email protected]>; +Cc: [email protected] Hi Christoph, On Sat, 2023-11-04 at 10:50 +0100, Christoph Berg wrote: > it looks like https://github.com/uber/h3 hasn't been packaged yet, > which makes this a bit more complicated. > > I'll see if I can find the time to package both There are some overlapping files between h3 and h3-pg. I did not check closely, but you may not have to package h3. Just a FYI. Cheers, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-05 11:02 Christoph Berg <[email protected]> parent: Devrim Gündüz <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Christoph Berg @ 2023-11-05 11:02 UTC (permalink / raw) To: Devrim Gündüz <[email protected]>; +Cc: Regina Obe <[email protected]>; [email protected] Re: Devrim Gündüz > There are some overlapping files between h3 and h3-pg. I did not check > closely, but you may not have to package h3. Just a FYI. It took me a while to figure out because it was hidden in an unexpected location, but the reason h3-pg can be compiled without h3 is that it downloads it at build time: CMakeLists.txt: # Include core library add_subdirectory(cmake/h3) cmake/h3/CMakeLists.txt: FetchContent_Declare( h3 URL https://github.com/uber/h3/archive/refs/tags/v${H3_CORE_VERSION}.tar.gz URL_HASH SHA256=${H3_CORE_SHA256} ) FetchContent_MakeAvailable(h3) Deleting the line from CMakeLists.txt made it properly use the system-installed libh3. Regina: postgresql-NN-h3 packages are in the repository. Christoph ^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Include h3-pg extension @ 2023-11-05 21:55 Regina Obe <[email protected]> parent: Christoph Berg <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Regina Obe @ 2023-11-05 21:55 UTC (permalink / raw) To: 'Christoph Berg' <[email protected]>; 'Devrim Gündüz' <[email protected]>; +Cc: [email protected] > Deleting the line from CMakeLists.txt made it properly use the system-installed > libh3. > > Regina: postgresql-NN-h3 packages are in the repository. > > Christoph Great thanks very much. I just tried and works great so far. apt update apt postgresql-16-h3 and was able to install with CREATE EXTENSION h3_postgis CASCADE; Devrim, While I have you. I didn't check if yum.postgresql.org is carrying it. Would be great if it did too. Thanks, Regina ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-05 21:56 Devrim Gündüz <[email protected]> parent: Regina Obe <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Devrim Gündüz @ 2023-11-05 21:56 UTC (permalink / raw) To: Regina Obe <[email protected]>; 'Christoph Berg' <[email protected]>; +Cc: [email protected] Hi, On Sun, 2023-11-05 at 16:55 -0500, Regina Obe wrote: > While I have you. I didn't check if yum.postgresql.org is carrying > it. Would be great if it did too. Pushed the packages a few mins ago: h3, and h3-devel: h3 RPMs pg-h3_XY : Extension RPMS Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-05 22:00 Christoph Berg <[email protected]> parent: Devrim Gündüz <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Christoph Berg @ 2023-11-05 22:00 UTC (permalink / raw) To: Devrim Gündüz <[email protected]>; +Cc: Regina Obe <[email protected]>; [email protected] Re: Devrim Gündüz > > While I have you. I didn't check if yum.postgresql.org is carrying > > it. Would be great if it did too. > > h3, and h3-devel: h3 RPMs > pg-h3_XY : Extension RPMS 5.11.23 22:55 Regina Obe pgsql-pkg- RE: Include h3-pg extension 5.11.23 22:56 Devrim Gündüz └─> That must be a new record :D Christoph ^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Include h3-pg extension @ 2023-11-05 22:30 Regina Obe <[email protected]> parent: Christoph Berg <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Regina Obe @ 2023-11-05 22:30 UTC (permalink / raw) To: 'Christoph Berg' <[email protected]>; 'Devrim Gündüz' <[email protected]>; +Cc: [email protected] > Re: Devrim Gündüz > > > While I have you. I didn't check if yum.postgresql.org is carrying > > > it. Would be great if it did too. > > > > h3, and h3-devel: h3 RPMs > > pg-h3_XY : Extension RPMS > > 5.11.23 22:55 Regina Obe pgsql-pkg- RE: Include h3-pg extension > 5.11.23 22:56 Devrim Gündüz └─> > > That must be a new record :D > > Christoph Yes that was quick. Thanks to both of you. Devrim, just confirming you have it only for Rocky / Redhat/ CentOS 8 or above right. Not seeing it for the 7 series. Which is fine, just confirming. Thanks, Regina ^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Include h3-pg extension @ 2023-11-05 22:42 Devrim Gündüz <[email protected]> parent: Regina Obe <[email protected]> 0 siblings, 0 replies; 9+ messages in thread From: Devrim Gündüz @ 2023-11-05 22:42 UTC (permalink / raw) To: Regina Obe <[email protected]>; 'Christoph Berg' <[email protected]>; +Cc: [email protected] Hi Regina, On Sun, 2023-11-05 at 17:30 -0500, Regina Obe wrote: > Yes that was quick. Thanks to both of you. I actually started working on them yesterday :-) > > Devrim, just confirming you have it only for Rocky / Redhat/ CentOS 8 > or above right. Not seeing it for the 7 series. Which is fine, just > confirming. Already stopped adding new packages to RHEL 7: https://yum.postgresql.org/news/rhel7-postgresql-rpms-end-of-life/ Cheers, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR ^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2023-11-05 22:42 UTC | newest] Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-11-04 02:44 Include h3-pg extension Regina Obe <[email protected]> 2023-11-04 09:50 ` Christoph Berg <[email protected]> 2023-11-05 00:37 ` Devrim Gündüz <[email protected]> 2023-11-05 11:02 ` Christoph Berg <[email protected]> 2023-11-05 21:55 ` Regina Obe <[email protected]> 2023-11-05 21:56 ` Devrim Gündüz <[email protected]> 2023-11-05 22:00 ` Christoph Berg <[email protected]> 2023-11-05 22:30 ` Regina Obe <[email protected]> 2023-11-05 22:42 ` Devrim Gündüz <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox