May 2023 Bugfix + Feature Release

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)

Postgres.app 2.6.1

This release fixes issues #695 and #708

PostgreSQL Bugfixes February 2023

This release contains the latest bugfix updates of PostgreSQL and PostGIS.

• PostgreSQL 15.2 with PostGIS 3.3.2
• PostgreSQL 14.7 with PostGIS 3.2.4
• PostgreSQL 13.10 with PostGIS 3.1.8
• PostgreSQL 12.14 with PostGIS 3.0.8
• PostgreSQL 11.19 with PostGIS 2.5.9

This release removes PostgreSQL 10. If you are still using PostgreSQL 10, please create a dump before upgrading the app.

The release notes and the release announcement can be found on the PostgreSQL homepage

We've also made improvements to the GUI:

• Postgres.app now automatically creates a server with the newest version if you upgrade (see #694)
• Posgres.app can now be launched from other folders (not just /Applications). See issue #693, and this documentation page.

Relocatable Postgres.app

This is the first relocatable build of Postgres.app.

The big change is that you can now ignore the warning that Postgres.app is not in /Applications.

This is a first test release, here are the most important know issues:

• After clicking "launch anyway" in the dialog, something prevents the ui from being shown. Click the dock icon to show the UI.
• When you move Postgres.app, your existing servers will stop working. To fix them, remove them from the sidebar, then add them again.
• Autostarting servers on login doesn't work if Postgres.app is not in /Applications
• Showing the Postgres icon in the menu item on login doesn't work if Postgres.app is not in /Applications
• the instructions for adding the command line tools to your path need to be updated

This main reason for publishing this build is to see if any issues arise from moving PostgreSQL binaries around. I'm not sure if there are any hardcoded paths in PostgreSQL or in extensions that could cause issues.

November 2022 Bugfix Releases

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

• PostgreSQL 10.23 with PostGIS 2.4.10
• PostgreSQL 11.18 with PostGIS 2.5.8
• PostgreSQL 12.13 with PostGIS 3.0.7
• PostgreSQL 13.9 with PostGIS 3.1.7
• PostgreSQL 14.6 with PostGIS 3.2.3
• PostgreSQL 15.1 with PostGIS 3.3.1

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

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

PostgreSQL 15

Enjoy the all new PostgreSQL 15 with PostGIS 3.3.1!

• PostgreSQL 15 Release Notes: https://www.postgresql.org/docs/release/15.0/
• PostGIS 3.3.1 Release Notes: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.3.1/NEWS
• The bundled PL/Python requires Python 3.11 from python.org
• Databases initialised with PostgreSQL 15 will use ICU collations by default, so you finally get consistent and reasonable text sorting on macOS (see #216)
• data_checksums are now enabled by default (when initialising a server with PG 15)
• PostgreSQL is built with Zstandard (zstd) and LZ4 support, so you can use all the new compression methods for backups, WAL and TOAST

PostgreSQL 15 RC 2

Your last chance to test PG 15 before the official release next week!

Ventura Compatibility Release

This release improves compatibility with macOS Ventura.

• we've changed the way Postgres.app starts when you log in. Instead of using a launch agent, Postgres.app now registers a login item on macOS 13. This fixes the problem reported in issue #677 where macOS said that "Jakob Egger added a login item". The warning now shows the app name (as expected). If you don't want Postgres.app to start servers when you log in, you can use the new toggle in System Preferences to turn it off.
• this release also include PostgreSQL 15beta4
• this update also contains bugfix releases of PostGIS

Test Release

This is a test release of Postgres.app to check compatibility with macOS Ventura.

• should fix the "Jakob Egger" problem (issue #677)
• should also fix incorrect "Port in use" error
• fixes an issue in the previous test build where the "show in menubar" checkbox didn't work

Test Release

This is a test release of Postgres.app to check compatibility with macOS Ventura.

• should fix the "Jakob Egger" problem (issue #677)
• should also fix incorrect "Port in use" error