PostGIS 3.0.0alpha2

The PostGIS development team is pleased to release PostGIS 3.0.0alpha2.

This release works with PostgreSQL 9.5-12beta1 and GEOS >= 3.6

Best served with PostgreSQL 12beta1.


View all closed tickets for 3.0.0.

Changes since PostGIS 3.0.0alpha1 release are as follows:

  • 4404, Fix selectivity issue with support functions (Paul Ramsey)
  • 4311, Make wagyu the default option to validate polygons. This option requires a C++11 compiler and will use CXXFLAGS (not CFLAGS). It only enabled if built with MVT support (protobuf) and should speed up mvt tile generations Add --without-wagyu to disable this option and keep the behaviour from 2.5 (Raúl Marín)
  • 4198, Add ST_ConstrainedDelaunayTriangles SFCGAL function (Darafei Praliaskouski)

Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension. If you are upgrading from a previous edition, do the following:

After installing the binaries or after running pg_upgrade, make sure to do:

2-- this next step repackages raster in its own extension
3-- and upgrades all your other related postgis extension
4SELECT PostGIS_Extensions_Upgrade();
6--if you don't use raster, you can do
7DROP EXTENSION postgis_raster;

-- New users

2CREATE EXTENSION postgis_raster;
3CREATE EXTENSION postgis_topology;
4CREATE EXTENSION postgis_tiger_geocoder;

If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version packaged with these releases.