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

Included PostgreSQL and PostGIS versions

• PostgreSQL 18.1 with PostGIS 3.6.0
• 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

You can find an overview of the PostgreSQL fixes in the Release Announcement, and all the details in the Release Notes.

What else is new?

• A possible crash in the auth_permission_dialog extension has been fixed and users should now get a proper error message in the rare cases where the Permission Dialog can not be displayed.
• A possible crash of the GUI when connecting to servers while the Preferences window is open was resolved (#829)
• The pljs extension, which is bundled with PostgreSQL 14 and later, has been updated to 1.0.3. If you use it, make sure you run the command ALTER EXTENSION pljs UPDATE;.
• The vector extension, which is bundled with PostgreSQL 15 and later, has been updated to 8.0.1. If you use it, make sure you run the command ALTER EXTENSION vector UPDATE;.

PostGIS

The version of PostGIS included with PostgreSQL 17 has been updated. 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();

Please be aware that PostGIS 3.6.0, which is included with PostgreSQL 18, contains a bug in the postgis_topology extension that may corrupt existing topology data. This has been fixed with PostGIS 3.6.1 included in the v2.9.2 release of Postgres.app

PostgreSQL 13 EOL

If you are still using PostgreSQL 13, please upgrade soon. This will likely be the final update for PostgreSQL 13 before it reaches the end of its support period.