This release includes the latest quarterly bug and security fixes for PostgreSQL, as well as other updates.

Note: The PostgreSQL project has announced that these releases contain regressions in the substring() function on multi-byte text values and with WAL replay on a standby server. If you are depending on these features, please wait for the fixed releases scheduled for next week and stick with v2.9.2 until then.

Included PostgreSQL and PostGIS versions

• PostgreSQL 18.2 with PostGIS 3.6.2
• PostgreSQL 17.8 with PostGIS 3.5.5
• PostgreSQL 16.12 with PostGIS 3.4.5
• PostgreSQL 15.16 with PostGIS 3.3.8
• PostgreSQL 14.21 with PostGIS 3.2.8

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 indexes on ltree columns that may require a reindex post-upgrade.

What else is new?

• A potential crash in the Permission Dialog has been fixed that could occur if the client application that is trying to connect was running translocated.
• The pljs extension has been updated to 1.0.5. If you use it, make sure you run the command ALTER EXTENSION pljs UPDATE;.
• Several dependencies got minor updates.

Upgrading PostGIS

The version of PostGIS included with PostgreSQL 16-18 has been updated to 3.4.5, 3.5.5 and 3.6.2 respectively. 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();

For PostgreSQL 18: If you are using postgis_topology and have topogeometry columns, and you are upgrading from a version earlier than PostGIS 3.6.1, make sure you run the following function after upgrading to fix any topogeometry corruption:

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

The PostGIS updates for PostgreSQL 14 and 15 will be delivered with the next release, after a bug with upgrades has been fixed.

PostgreSQL 13 EOL

This release removes PostgreSQL 13 as it is no longer supported. If you are still using PostgreSQL 13, please create a dump before upgrading.