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

Included PostgreSQL and PostGIS versions

• PostgreSQL 17.6 with PostGIS 3.5.3
• PostgreSQL 16.10 with PostGIS 3.4.4
• PostgreSQL 15.14 with PostGIS 3.3.8
• PostgreSQL 14.19 with PostGIS 3.2.8
• PostgreSQL 13.22 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. As before, there are rare cases that may require reindexing of BRIN indexes.

What else is new?

• A semi-automatic crash reporter has been added, which checks for crash reports when the application starts up and offers to send them to the developers for analysis.
• OpenSSL has been updated to supported LTS releases. For PostgreSQL 13 and 14, this means that support for certain legacy digest algorithms and ciphers, which could previously be accessed via the pgcrypto extension, has been removed (see #804). There shouldn't be any impact for PostgreSQL 15 - 17.
• The pljs extension, which is bundled with PostgreSQL 14 and later, has reached its 1.0 milestone and has been updated. If you use it, make sure you run the command ALTER EXTENSION pljs UPDATE;.
• Several bugs, including a crash on macOS 12 and earlier (#822), have been resolved.

Upgrading 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();

For downloads including PostgreSQL 18 Beta 3, please see Postgres.app 2.9beta.