PostGIS 3.0.0alpha2

Jun 2, 2019 release 3

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.

3.0.0alpha2

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:

ALTER EXTENSION postgis UPDATE;
-- this next step repackages raster in its own extension
-- and upgrades all your other related postgis extension
SELECT PostGIS_Extensions_Upgrade();

--if you don't use raster, you can do
DROP EXTENSION postgis_raster;

– New users

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_raster;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION postgis_tiger_geocoder;

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