Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

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.


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:

-* 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_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.