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

PostGIS 3.6.1

The PostGIS Team is pleased to publish PostGIS 3.6.1. This is a bug fix release that includes bug fixes since PostGIS 3.6.0.

  • This version requires PostgreSQL 12 - 18, Proj 6.1+, and GEOS 3.8+. 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.

3.6.1

Fixes

  • #5978, geometry_columns needs to still parse table constraints (Paul Ramsey)
  • #5987, ST_GeometryN fails for non-collections (Paul Ramsey)
  • #5991, CircularString distance error (Paul Ramsey)
  • #5994, Null pointer in ST_AsGeoJsonRow (Alexander Kukushkin)
  • #5998, ST_Distance error on CurvePolygon (Paul Ramsey)
  • #5962, Consistent clipping of MULTI/POINT (Paul Ramsey)
  • #5998, [tiger_geocoder] [security] CVE-2022-2625, make sure tables requires by extension are owned by extension authored: Andrey Borodin (Yandex), reported by Sergey Bobrov (Kaspersky)
  • #5754, ST_ForcePolygonCCW reverses lines (Paul Ramsey)
  • #5959, #5984, Prevent histogram target overflow when analysing massive tables (Darafei Praliaskouski)
  • #6012, Remove memory leak from lwcircstring_from_lwpointarray (Paul Ramsey)
  • #6013, [tiger_geocoder] Load Tiger 2025 data (Regina Obe)
  • #5983, [topology] topology.FixCorruptTopoGeometryColumn to fix corruption caused by 3.6.0 upgrade (Regina Obe, Francois Bonzon)

Upgrading

After installing the binaries or after running pg_upgrade:

For PostGIS 3.0 and higher, do below which will upgrade all your postgis extensions.

SELECT postgis_extensions_upgrade();

If you are upgrading postgis_topology and have topogeometry columns, make sure to run after the upgrade to fix topogeometry corruption:

SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_column)
  FROM topology.layer;

Other Issues

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

View all tickets for 3.6.1 milestone.