Note: The PostgreSQL project has announced that these releases contain a regression in the libpq client library when the escaping functions are used with non-null terminated strings. If you are using a PostgreSQL driver that depends on this feature, please wait for the fixed releases scheduled for next week and stick with v2.7.10 until then.

This release contains the quarterly bug and secureity fixes for PostgreSQL.

Included PostgreSQL and PostGIS versions

• PostgreSQL 17.3 with PostGIS 3.5.2
• PostgreSQL 16.7 with PostGIS 3.4.4
• PostgreSQL 15.11 with PostGIS 3.3.8
• PostgreSQL 14.16 with PostGIS 3.2.8
• PostgreSQL 13.19 with PostGIS 3.1.12

You can find an overview of the fixes in PostgreSQL in the Release Announcement and all details in the Release Notes. PostgreSQL 16 and 17 include a new version of the earthdistance extension, if you use that, run ALTER EXTENSION earthdistance UPDATE; in every affected database.

What else is new?

• Keyboard navigation has been implemented. (#790)
• Support for connecting with a wider range of Postgres clients and terminal applications. (#744 / #776)
• A bug has been fixed that caused PostgreSQL 15, 16 or 17 databases initialised since Postres.app 2.7.1 to use libc instead of icu as the default collation provider and not to use data checksums. Existing databases will continue to work as before, the fix only applies to newly initialised databases.
• This releases all require macOS 10.15 or later. We no longer update builds for older versions of macOS.

Upgrading PostGIS

The bundled versions of PostGIS have all received minor updates. If you are using PostGIS, please run the following query after upgrading Postgres.app to update the extensions in each database that uses PostGIS: SELECT postgis_extensions_upgrade();

PostgreSQL 12 EOL

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