PostGIS 3.0.0rc1

Oct 8, 2019 release 3

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

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

Best served with PostgreSQL 12 , GEOS 3.8.0rc2 and pgRouting 3.0.0-alpha.

3.0.0rc1

Main changes since PostGIS 3.0.0beta1 release are as follows:

#4519, Fix getSRIDbySRS crash (Raúl Marín)
#4520, Use a clean environment when detecting C++ libraries (Raúl Marín)
Restore ST_Union aggregate signature so drop agg not required and re-work performance/size enhancement to continue to avoid using Array type during ST_Union, hopefully avoiding Array size limitations. (Paul Ramsey)

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.