PostGIS 3.5.3

The PostGIS Team is pleased to release PostGIS 3.5.3.

This version requires PostgreSQL 12 - 18beta1, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is needed to enable postgis_sfcgal support. To take advantage of all SFCGAL features, SFCGAL 1.5+ is needed.

• source download md5

• NEWS

• PDF docs: en

• HTML Online en ja fr zh_Hans

• Cheat Sheets:

  • postgis: en ja fr zh_Hans
  • postgis_raster: en ja fr zh_Hans
  • postgis_topology: en ja fr zh_Hans
  • postgis_sfcgal: en ja fr zh_Hans
  • address standardizer, postgis_tiger_geocoder: en ja fr zh_Hans

This release is a bug fix release that includes bug fixes since PostGIS 3.5.1.

• Do not complain about illegal option when calling shp2pgsql -? (Sandro Santilli, Giovanni Zezza)
• #5862, [topology] Prevent another topology corruption with TopoGeo_addPoint near almost collinear edges (Sandro Santilli)
• #5841, Change approach to interrupt handling to conform to PgSQL recommended practice (Paul Ramsey)
• #5855, Fix index binding in ST_DFullyWithin (Paul Ramsey)
• #5819, Support longer names in estimated extent (Paul Ramsey)
• Fix misassignment of result in _lwt_HealEdges (Maxim Korotkov)
• #5876, ST_AddPoint with empty argument adds garbage (Paul Ramsey)
• #5874, Line substring returns wrong answer (Paul Ramsey)
• #5829, geometry_columns with non-standard constraints (Paul Ramsey)
• #5818, GT-244 Fix CG_IsSolid function (Loïc Bartoletti)
• #5885, Fix documentation about grid-based overlay operations (Sandro Santilli)
• For SFCGAL 2.1.0+ prevent using deprecated functions (Regina Obe)

After installing the binaries or after running pg_upgrade:

For PostGIS 3.5, 3.4, 3.3, 3.2, 3.1, 3.0 do below which will upgrade all your postgis extensions.

SELECT postgis_extensions_upgrade();

For PostGIS 2.5 and below do:

ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();

If you come across any issues, feel free to report via our ticket tracker or mailing list with details

View all tickets for 3.5.3 milestone.