PostGIS 3.0.0rc1

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

• source download
• NEWS
• PDF docs en de
• html doc download
• html online en, de, ko_KR, ja
• epub doc download
• Changelog

View all closed tickets for 3.0.0.

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:

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

-* New users

1CREATE EXTENSION postgis;
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.