This release features the all new PostgreSQL 18 and PostGIS 3.6.0.

Easier Extension Installation

Postgres.app has always shipped with a number of popular extensions, but starting with PostgreSQL 18 it is now easier than ever to install custom extensions. You can either build them yourself, or install a number of precompiled extensions available as a separate download. See https://postgresapp.com/extensions/ for more information.

Release Announcement

For a full list of changes, please refer to the PostgreSQL Release Announcement and the PostgreSQL Release Notes.

This release also updates PostGIS to 3.6.0 and continues the upgrades of its dependencies to their latest major versions, notably GEOS. pljs has also received some bugfixes.

What else is new

• If possible, the GUI crash reporter now also searches for diagnostic reports stored outside the user's home directory.
• A fix has been implemented in the Permission Dialog that should resolve the Postgres.app failed to verify "trust" authentication errors that some users experienced.