pg14-postgis3 (databases/postgis3) Updated: 3 months, 3 weeks ago Add to my watchlist

PostGIS is the spatial extension to the PostGreSQL database.

PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.

Version: 3.4.2 License: GPL-2+ GitHub
Maintainers Veence nilason
Categories databases gis
Platforms darwin
  • lto (Build with Link Time Optimization (LTO))
  • raster (Build raster support)
  • sfcgal (Uses SFCGAL for 3D queries)
  • universal (Build for multiple architectures)

Subport(s) (10)

"pg14-postgis3" depends on

lib (9)
build (6)

Ports that depend on "pg14-postgis3"

Port notes

! This version comes with the following warning if you use postgresql14:
‘Due to some query performance degradation with the new fast index build
that requires PG14, we have decided to disable the feature by default
until we get more user testing as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing:

ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);

and then reindex your gist indexes.
To revert back to the old index behavior:

ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
DROP FUNCTION 11 (geometry);

and then reindex your gist indexes.’

Port Health:

Loading Port Health

Installations (30 days)


Requested Installations (30 days)