h3_postgis

H3 PostGIS integration

Overview

ID	Extension	Package	Version	Category	License	Language
1531	h3_postgis	pg_h3	`4.2.3`	GIS	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
Requires	h3 postgis postgis_raster
See Also	mobilitydb postgis_topology postgis_sfcgal postgis_tiger_geocoder address_standardizer address_standardizer_data_us pgrouting pointcloud
Siblings	h3

no el8.pg17.x86

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`4.2.3`	18 17 16 15 14 13	`h3-pg_$v*`	-
Debian	PGDG	`4.2.3`	18 17 16 15 14 13	`postgresql-$v-h3`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	MISS	MISS	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el8.aarch64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el9.x86_64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el9.aarch64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el10.x86_64	PGDG 4.2.3	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2
el10.aarch64	PGDG 4.2.3	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2
d12.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d12.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d13.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d13.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u22.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u22.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u24.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u24.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3

Source

Repository

github.com/zachasme/h3-pg

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install h3_postgis; # install by extension name, for the current active PG version
pig ext install pg_h3; # install via package alias, for the active PG version
pig ext install h3_postgis -v 18;   # install for PG 18
pig ext install h3_postgis -v 17;   # install for PG 17
pig ext install h3_postgis -v 16;   # install for PG 16
pig ext install h3_postgis -v 15;   # install for PG 15
pig ext install h3_postgis -v 14;   # install for PG 14
pig ext install h3_postgis -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION h3_postgis;

Last updated on 2025-11-02

h3 q3c