The PostgreSQL project has announced an out-of-cycle bug fix release due to regressions in the Feb 12 releases.

If you are updating from Postgres.app 2.9.2 or earlier, please also see the Postgres.app 2.9.3 release notes.

Included PostgreSQL and PostGIS versions

• PostgreSQL 18.3 with PostGIS 3.6.2
• PostgreSQL 17.9 with PostGIS 3.5.5
• PostgreSQL 16.13 with PostGIS 3.4.5
• PostgreSQL 15.17 with PostGIS 3.3.9
• PostgreSQL 14.22 with PostGIS 3.2.9

You can find an overview of the PostgreSQL fixes in the Release Announcement, and all the details in the Release Notes. In particular, for PostgreSQL 18 there is a note about the volatility marking of the json_strip_nulls() and jsonb_strip_nulls() functions that can be corrected in existing databases by a catalog update.

Upgrading PostGIS

The version of PostGIS included with PostgreSQL 14-15 has been updated to 3.2.9 and 3.3.9 including patches for the postgis_tiger_geocoder upgrade issue. If you use PostGIS in these versions, please run the following query after upgrading Postgres.app to update the extensions in any databases using PostGIS: SELECT postgis_extensions_upgrade();