Postgres.app now shows a permission prompt when an app attempts to connect for the first time. For more information, see https://postgresapp.com/documentation/app-permissions.html

This release also contains the latest versions of PostGIS and GEOS. The following PostgreSQL versions are available:

• PostgreSQL 11.22 with PostGIS 2.5.9
• PostgreSQL 12.17 with PostGIS 3.0.10
• PostgreSQL 13.13 with PostGIS 3.1.10
• PostgreSQL 14.10 with PostGIS 3.2.6
• PostgreSQL 15.5 with PostGIS 3.3.5
• PostgreSQL 16.1 with PostGIS 3.4.1

If you are using PostGIS, remember to run SELECT postgis_extensions_upgrade(); for each PostGIS enabled database to update the extension's SQL definitions.

This release also includes a minor bug fix where the app did not activate correctly when opened from the menu item (issue #743).

The November builds with PostgreSQL 12, 13, 14 and 15 were missing the "latest" symlink (#735).

This release fixes this issue. It is otherwise identical to 2.6.8.

This release contains the latest bugfixes for all supported versions of PostgreSQL.

• PostgreSQL 16.1 with PostGIS 3.4.0
• PostgreSQL 15.5 with PostGIS 3.3.4
• PostgreSQL 14.10 with PostGIS 3.2.5
• PostgreSQL 13.13 with PostGIS 3.1.9
• PostgreSQL 12.17 with PostGIS 3.0.9
• PostgreSQL 11.22 with PostGIS 2.5.9

Notable changes since Postgres.app 2.6.7:

• PostGIS: support for writeable MVT in OGR
• PostGIS: support for netCDF in GDAL / OGR (#731) with PostgreSQL 16
• New versions of extensions pgrouting and pgvector. Run ALTER EXTENSION ... UPDATE to update
• PostgreSQL got several fixes affecting index creation and maintenance. Please check the release notes whether or not your databases may be affected and reindexing would be advisable.
• Fixed an issue where Postgres.app didn't auto-start when not in /Applications
• Fixed an issue where Postgres.app didn't launch on macOS 10.13 when not in /Applications

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

This will likely be the final release of PostgreSQL 11. If you still have databases running on PostgreSQL 11, you should consider upgrading your database after installing this update.

The single version releases containing PostgreSQL 12, 13, 14 and 15 have been withdrawn, please refer to the fixed downloads in the 2.6.8a Release.

Enjoy the all new PostgreSQL 16 with PostGIS 3.4!

• PostgreSQL 16 Release announcement and detailed Release Notes
• PostGIS 3.4.0 (Release notes) with upgraded dependencies incl. GDAL 3.7 and Proj 9.2
• The bundled PL/Python requires Python 3.12 from python.org
• pgvector extension upgraded to version 0.5.0
• Postgres.app is now relocatable! This means you can start it from any location, not just from the /Applications folder. For details, see issue #693

The PostgreSQL versions 11 - 15 have not received an update this time and are the same as in the Postgres.app v2.6.5 bundle for all versions.

If you want to upgrade your existing database to PostgreSQL 16, please note that you need to migrate your data.

This update includes PostgreSQL 16 Release Candidate and PostGIS 3.4.0

This set of releases contains the latest bugfixes for PostgreSQL and includes PostgreSQL 16 Beta 3 with PostGIS 3.4.

Additionally, OpenSSL and some PostGIS dependencies got updates and support for several file formats was fixed in OGR (#724)

• PostgreSQL 16beta3 with PostGIS 3.4.0rc1
• PostgreSQL 15.4 with PostGIS 3.3.4
• PostgreSQL 14.9 with PostGIS 3.2.5
• PostgreSQL 13.12 with PostGIS 3.1.9
• PostgreSQL 12.16 with PostGIS 3.0.9
• PostgreSQL 11.21 with PostGIS 2.5.9

The release notes and the release announcement can be found on the PostgreSQL homepage. In particular, there is a note about BRIN-Indexes and NULL values that may require a post-upgrade step.

This set of releases includes PostgreSQL 16 Beta 2. We now also include PostGIS again in the beta release!

Additionally, PG 15 and PG 16 now come with the extension pgrouting.

Additionally, these builds include the latest PostGIS and OpenSSL bugfix releases.

See the release notes for PostgreSQL 16 Beta 2: https://www.postgresql.org/about/news/postgresql-16-beta-2-released-2665/

This is the first Beta version of PostgreSQL 16.

We have not yet included PostGIS with PostgreSQL 16 because there is no compatible release available yet.

New Features

@tbussmann has been hard at work to include two new extensions with PostgreSQL 15:

• The pgvector extension is now included (see #716)
• PostGIS is finally built with support for SFCGAL! (see #337, #529, #685)

We've also added a feature to the GUI that allows setting/resetting PostgreSQL user passwords (#718).

Bugfixes

• This release comes with the quarterly PostgreSQL bug fix releases (15.3, 14.8, 13.11, 12.15, 11.20). See the release notes for details
• we've added a patch that fixes a problem with pg_basebackup (#715)

This release fixes issues #695 and #708