This release updates PostGIS for PostgreSQL 18 to fix a data corruption bug with topologies. In addition, a possible crash in the xml2 contrib extension should be fixed. The PostgreSQL 13–17 binaries are identical to those in the 2.9.1 Postgres.app release. For more information and downloads, please refer to that release.

Included PostgreSQL and PostGIS versions

• PostgreSQL 18.1 with PostGIS 3.6.1
• PostgreSQL 17.7 with PostGIS 3.5.4
• PostgreSQL 16.12 with PostGIS 3.4.4
• PostgreSQL 15.15 with PostGIS 3.3.8
• PostgreSQL 14.20 with PostGIS 3.2.8
• PostgreSQL 13.23 with PostGIS 3.1.12

PostGIS

The version of PostGIS included with PostgreSQL 18 has been updated to 3.6.1. If you use PostGIS, please run the following query after upgrading Postgres.app to update the extensions in any databases using PostGIS: SELECT postgis_extensions_upgrade();

This fixes the bug in the postgis_topology extension that was corrupting existing topology data, among other fixes. If you use this extension and have topogeometry columns, run the following function after upgrading to fix any topogeometry corruption:

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