Swiftpack.co - Package - PostgresApp/PostgresApp

Postgres.app

The easiest way to run PostgreSQL on your Mac

  • Includes everything you need to get started with PostgreSQL
  • Comes with a pretty GUI to start / stop servers
  • Run Multiple Versions of PostgreSQL simultaneously

Download

You can download recent versions of Postgres.app from the Postgres.app website.

Older versions and pre-releases are available in the releases section on GitHub.

Documentation

Documentation is available at http://postgresapp.com/documentation, as well as from the "Open Documentation" menu item in Postgres.app.

What's Included?

How To Build

Postgres.app consists of separate parts:

  1. The PostgreSQL binaries, including extensions and a bunch of command line tools. You can find the binaries in /Applications/Postgres.app/Contents/Versions

  2. The Postgres.app user interface, written in Swift. This is the native Mac app that you see when you double click Postgres.app in the Finder.

For compatibility reasons we build the different parts on different versions of macOS.

  • the binaries for PostgreSQL 9.4 - 10 are built on macOS 10.10 with Xcode 7.2.1

  • the binaries for PostgreSQL 11 - 12 are built on macOS 10.12 with Xcode 8.3.3

  • the GUI is built on macOS 10.15 with Xcode 10.1

It is of course possible to use other versions of macOS / Xcode (see details below), but those are the environments we use.

Building the GUI

If you want to work on the user interface only, you don't have to re-compile the binaries yourself. By default, the buildscript for Postgres.app just copies the binaries from /Applications/Postgres.app/Contents/Versions

So just make sure you have a copy of Postgres.app in your applications folder. Open the XCode file and start hacking!

Tools required for building the GUI:

  • Xcode 10.1

Currently it is not possible to use Xcode 11 because Postgres.app is written in Swift 3. Any help migrating to Swift 5 would be greatly appreciated!

Building the Binaries

If you want to build your own versions of all the PostgreSQL binaries, you have slightly more work to do.

The directories src-10, src-11 and src-12 each contain a makefile that downloads and builds all the binaries. If you have all the prerequisites installed (see below), you can just type make.

The makefile will download and build many gigabytes of sources. The default target (all) builds postgresql, postgis, plv8, and wal2json. PostGIS and especially plv8 take a long time to build, so if you don't need them, type make postgresql instead.

The makefile will install all products in /Applications/Postgres.app/Contents/Versions/xx (xx is the major version of PostgreSQL). So for best results, make sure that directory is empty before starting the build.

If you want to change the version number of any of the dependencies, edit the makefile (all version numbers are specified at the top).

You can use the -j option (eg. make -j 3 postgresql) for parallel builds. My recommendation is to use one more job than the number of logical processors you have. Since my macOS 10.12 VM is limited to 2 virtual CPUs, I use -j 3. However, parallel builds make debugging problems a lot harder, so don't use them when something doesn't work.

Always check the exit code of make to see if any errors occurred, eg. make -j 3 || echo "Build failed with exit code $?"

Prerequisites for building the binaries

At the very least, you need the following:

  • Xcode
  • Developer Tools (install with xcode-select -install)

For building PostGIS, you also need

  • autoconf
  • automake
  • pkgconfig (when building GDAL 3.0.0 or later)
  • libtool

By default, PostgreSQL is built with documentation. To build the docs, you need:

  • docbook-dsssl
  • docbook-sgml-4.2
  • docbook-xml-4.2
  • docbook-xsl-nons
  • libxslt
  • openjade
  • opensp

The quickest way to install all the dependencies is with MacPorts. Install MacPorts, then type:

sudo port -N install autoconf automake pkgconfig libtool docbook-dsssl docbook-sgml-4.2 docbook-xml-4.2 docbook-xsl-nons libxslt openjade opensp

(The -N flag tells Macports to install required dependencies without asking)

It may also be possible to install those using homebrew, but I'm not sure if they have all the required packages.

Under the Hood

Postgres.app bundles the PostgreSQL binaries inside the application package. When you first start Postgres.app, here's what it does:

  • Initialise a database cluster: initdb -D DATA_DIRECTORY -EUTF-8 --locale=XX_XX.UTF-8
  • Start the server: pg_ctl start -D DATA_DIRECTORY -w -l DATA_DIRECTORY/postgres-server.log
  • Create a user database: createdb USERNAME

On subsequent app launches, Postgres.app only starts the server.

The default DATA_DIRECTORY is /Users/USERNAME/Library/Application Support/Postgres/var-9.X

Note that Postgres.app runs the server as your user, unlike other installations which might create a separate system user named postgres.

When you quit Postgres.app, it stops the server using the following command:

  • pg_ctl stop -w -D DATA_DIRECTORY

Command Line Utilities

Postgres.app also includes useful command line utilities (note: this list may be outdated):

  • PostgreSQL: clusterdb createdb createlang createuser dropdb droplang dropuser ecpg initdb oid2name pg_archivecleanup pg_basebackup pg_config pg_controldata pg_ctl pg_dump pg_dumpall pg_receivexlog pg_resetxlog pg_restore pg_standby pg_test_fsync pg_test_timing pg_upgrade pgbench postgres postmaster psql reindexdb vacuumdb vacuumlo
  • PROJ.4: cs2cs geod invgeod invproj nad2bin proj
  • GDAL: gdal_contour gdal_grid gdal_rasterize gdal_translate gdaladdo gdalbuildvrt gdaldem gdalenhance gdalinfo gdallocationinfo gdalmanage gdalserver gdalsrsinfo gdaltindex gdaltransform gdalwarp nearblack ogr2ogr ogrinfo ogrtindex testepsg
  • PostGIS: pgsql2shp raster2pgsql shp2pgsql

See the documentation for more info.

Using the debugger

First, you'll need to adjust the configuration file (postgresql.conf) to preload the debugger extension. Add the following line:

shared_preload_libraries = 'plugin_debugger'

After you've saved this file, restart the server. You'll need to load the debugger extension into the database you wish to debug using:

CREATE EXTENSION pldbgapi;

Debugging requires that you are a superuser. Please refer to the documentation for further information. This requires that you use a supported client, such as PgAdmin 4. The official documentation for the module can be accessed here.

Contact

If you find a bug, please open an issue.

Postgres.app is maintained by Jakob Egger.

License

Postgres.app is released under the PostgreSQL License. See LICENSE for additional information.

Github

link
Stars: 5349

Dependencies

Used By

Total: 0

Releases

Postgres.app with PostgreSQL 13 Beta 1 - 2020-05-21 21:25:59

The first beta of PostgreSQL 13 is now available! This version of Postgres.app includes all currently supported versions of PostgreSQL (9.5-12) and the first beta of PostgreSQL 13.

You can use it to try PostgreSQL 13 next to the version you normally use.

  • comes with PostgreSQL 13beta1 and PostGIS 3.1.0alpha1
  • this build doesn't include wal2json because it didn't build with PostgreSQL 13
  • it also doesn't include plv8, because I didn't have enough time to build it
  • it no longer includes PL/tcl and PL/Perl because they don't seem to be available on macOS 10.15
  • it still comes with PL/Python2, because I haven't figured out how to add python 3 support

Please note that beta versions are for evaluation purposes only. You are likely to encounter bugs of varying severity.

During the course of the beta, the on-disk data format often changes, so that your data directory might not be compatible with future beta versions. In that case you will have to dump and restore your database when switching to a newer beta version.

Postgres.app May 2020 Releases - 2020-05-14 15:46:53

This release contains the querterly updates of PostgreSQL.

We offer downloads with the following versions of PostgreSQL:

  • PostgreSQL 12.3 with PostGIS 3.0.1
  • PostgreSQL 11.8 with PostGIS 2.5.4
  • PostgreSQL 10.13 with PostGIS 2.4.8
  • PostgreSQL 9.6.18 with PostGIS 2.3.10
  • PostgreSQL 9.5.22 with PostGIS 2.2.8
  • PostgreSQL 9.4.26 with PostGIS 2.1.9

New in this release: All versions include the PL Debugger extension (See PR #571)

Please pick a download that contains the versions of PostgreSQL that you need. For example, Postgres-2.3.5-12.dmg comes with PostgreSQL 12, while Postgres-2.3.5-10-11-12.dmg comes with PostgreSQL 10, 11 and 12.

These downloads all require macOS 10.12 or later. We no longer update builds for older versions of macOS.

Postgres.app January 2020 Releases - 2020-01-25 11:34:40

This update fixes a few issues:

  • plv8 didn't work for PostgreSQL 12 (see #549)
  • GDAL was built without PostgreSQL drivers (see #548)

This is also the first release of Postgres.app using the new hardened runtime. The hardened runtime is a new feature of macOS that makes it harder for attackers to exploit macOS software, but it could interfere with some software features. Beginning in February 2020, it will be required for all new software releases on macOS.

Postgres.app December 2019 Update - 2019-12-11 15:13:02

This release addresses several issues that have been reported:

  • we removed support for Kerberos (see issues #537, #538, #539)
  • we attempted to fix an issue where Postgres.app could not open Terminal.app (#509)

Postgres.app Releases November 2019 - 2019-11-14 14:53:43

Quarterly PostgreSQL updates are here!

We offer downloads with the following versions of PostgreSQL:

  • PostgreSQL 12.1, PostGIS 3.0.0 and PL/v8 2.3.13
  • PostgreSQL 11.6, PostGIS 2.5.3 and PL/v8 2.3.13
  • PostgreSQL 10.11, PostGIS 2.4.8 and PL/v8 1.4.8
  • PostgreSQL 9.6.16, PostGIS 2.3.10 and PL/v8 1.4.8
  • PostgreSQL 9.5.20, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.25, PostGIS 2.1.9 and PL/v8 1.4.8

Please pick a download that contains the versions of PostgreSQL that you need. For example, Postgres-2.3.2-12.dmg comes with PostgreSQL 12, while Postgres-2.3.2-10-11-12.dmg comes with PostgreSQL 10, 11 and 12.

These downloads all require macOS 10.12 or later. We no longer update builds for older versions of macOS.

Bugfix Update - 2019-10-17 20:28:45

In the previous release, PostGIS 3 was built without json-c support. This release fixes this problem. (#526)

Postgres-2.3.1-12.dmg includes just the latest and greatest version of PostgreSQL:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13

If you still have some older databases on your Mac that you don't want to upgrade just yet, we also offer a bigger bundle: Postgres-2.3-10-11-12.dmg comes with 3 versions of PostgreSQL included:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

And if you still have PostgreSQL 9.5 or 9.6 databases running, we also offer the biggest bundle yet: Postgres-2.3.1-9.5-9.6-10-11-12.dmg with the following PostgreSQL versions included:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

These builds run on all Macs with macOS 10.12 or later.

PostgreSQL 12 - 2019-10-03 18:42:28

PostgreSQL 12 was released today!

We have two builds of Postgres.app available with the newest version of PostgreSQL.

Postgres-2.3-12.dmg includes just the latest and greatest version of PostgreSQL:

  • PostgreSQL 12.0, PostGIS 3.0.0beta1 and PL/v8 2.3.13

If you still have some older databases on your Mac that you don't want to upgrade just yet, we also offer a bigger bundle: Postgres-2.3-10-11-12.dmg comes with 3 versions of PostgreSQL included:

  • PostgreSQL 12.0, PostGIS 3.0.0beta1 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

These builds run on all Macs with macOS 10.12 or later.

Postgres.app Releases August 2019 - 2019-08-08 17:59:27

The quarterly PostgreSQL releases are here!

We have bugfix releases for PostgreSQL 9.4, 9.5, 9.6, 10 and 11, and a new beta version of PostgreSQL 12. The PostgreSQL 12 beta now includes PL/v8 again!

Here's a list of all the downloads included in this release:

The Beta bundle

In addition to PostgreSQL 12 beta 3, this download also includes the stable versions of PostgreSQL 10 and 11. So you can try PostgreSQL 12 while running your existing databases at the same time!

Postgres-2.3beta3.dmg comes with 3 versions of PostgreSQL:

  • PostgreSQL 12beta3, PostGIS 3.0.0alpha3 and PL/v8 2.3.12
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

Stable versions only for Macs running macOS 10.12 or later

The latest stable version is Postgres.app 2.2.5.

We offer two downloads:

  • Postgres-2.2.5-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • Postgres-2.2.5-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
    • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
    • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
    • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

Stable version for Macs running macOS 10.10 or later

Postgres-2.1.9.dmg comes with the following versions of PostgreSQL:

  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.24, PostGIS 2.1.9 and PL/v8 1.4.8

Postgres.app Security Releases June 2019 - 2019-06-20 12:27:40

This release fixes a security issue in PostgreSQL 10 and later. We recommend to update as soon as possible. For more details, see the PostgreSQL change log.

Also included in this release is the second beta version of PostgreSQL 12, and bugfixes for 9.x versions.

Here are all the downloads that are included in this release:

The Beta bundle

Postgres-2.3beta2.dmg comes with 3 versions of PostgreSQL:

  • PostgreSQL 12beta2, PostGIS 3.0.0alpha2
  • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8

For Macs running macOS 10.12 or later

The newest version is Postgres.app 2.2.4.

We offer two downloads:

  • Postgres-2.2.4-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
  • Postgres-2.2.4-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
    • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
    • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
    • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.10 or later

Postgres-2.1.8.dmg comes with the following versions of PostgreSQL:

  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.23, PostGIS 2.1.9 and PL/v8 1.4.8

PostgreSQL 12beta1 - 2019-05-23 12:27:29

This version of Postgres.app includes the first beta of PostgreSQL 12!

Postgres-2.3beta1.dmg comes with 3 versions of PostgreSQL:

  • PostgreSQL 12beta1, PostGIS 2.5.2
  • PostgreSQL 11.3, PostGIS 2.5.2 and PL/v8 2.3.11
  • PostgreSQL 10.8, PostGIS 2.4.7 and PL/v8 1.4.8

Unfortunately PL/v8 is not yet available for PostgreSQL 12beta1, because a few APIs for extensions seem to have changed.

Postgres.app Releases May 2019 - 2019-05-09 08:12:31

For Macs running macOS 10.12 or later

The newest version is Postgres.app 2.2.3.

We offer two downloads:

  • Postgres-2.2.3-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.3, PostGIS 2.5.2 and PL/v8 2.3.11
  • Postgres-2.2.3-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.3, PostGIS 2.5.2 and PL/v8 2.3.11
    • PostgreSQL 10.8, PostGIS 2.4.7 and PL/v8 1.4.8
    • PostgreSQL 9.6.13, PostGIS 2.3.9 and PL/v8 1.4.8
    • PostgreSQL 9.5.17, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.10 or later

Postgres.app 2.1.7 comes with the following versions of PostgreSQL:

  • PostgreSQL 10.8, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.13, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.17, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.8, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.13, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.17, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.22, PostGIS 2.1.9 and PL/v8 1.4.8

Postgres.app Releases Feb 2019 - 2019-02-14 13:23:16

Welcome to the 2019 Valentine's Day PostgreSQL update!

For Macs running macOS 10.12 or later

The newest version is Postgres.app 2.2.2.

We offer two downloads:

  • Postgres-2.2.2-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.2, PostGIS 2.5.1 and PL/v8 2.3.9
  • Postgres-2.2.2-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.2, PostGIS 2.5.1 and PL/v8 2.3.9
    • PostgreSQL 10.7, PostGIS 2.4.6 and PL/v8 1.4.8
    • PostgreSQL 9.6.12, PostGIS 2.3.8 and PL/v8 1.4.8
    • PostgreSQL 9.5.16, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.10 or later

Postgres.app 2.1.6 comes with the following versions of PostgreSQL:

  • PostgreSQL 10.7, PostGIS 2.4.6 and PL/v8 1.4.8
  • PostgreSQL 9.6.12, PostGIS 2.3.8 and PL/v8 1.4.8
  • PostgreSQL 9.5.16, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.7, PostGIS 2.4.6 and PL/v8 1.4.8
  • PostgreSQL 9.6.12, PostGIS 2.3.8 and PL/v8 1.4.8
  • PostgreSQL 9.5.16, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.21, PostGIS 2.1.9 and PL/v8 1.4.8

Postgres.app 2.2 with PostgreSQL 11 - 2018-10-18 16:36:18

Hello PostgreSQL 11!

This version of Postgres.app comes with:

  • PostgreSQL 11.0
  • PostGIS 2.5.0
  • plv8 2.3.8

Unfortunately we've had to bump the minimum required macOS version to 10.12. The reason for this is that a lot of things no longer build on earlier versions.

Starting with this version, we'll offer two separate DMGs:

  • Postgres-2.2-11.dmg contains only the latest version of PostgreSQL
  • Postgres-2.2-9.5-9.6-10-11.dmg contains four versions for maximum compatibility

If you just want PostgreSQL, get the smaller DMG. It includes everything you need to get started. If you need multiple versions of PostgreSQL for testing, get the big DMG.

PostgresApp 2.2beta3 (with PostgreSQL 11beta4 and PostGIS 2.5.0) - 2018-09-24 07:15:21

This is the latest pre-release build of Postgres.app with PostgreSQL 11 (Beta 4)

It includes the following versions of PostgreSQL:

  • PostgreSQL 11 Beta 4 with PostGIS 2.5.0
    It does not include plv8. I'm still working on that.
    This build also includes support for Mapbox Vector Tiles (see #412)
  • PostgreSQL 9.5.14 with PostGIS 2.2.7
  • PostgreSQL 9.6.10 with PostGIS 2.3.7
  • PostgreSQL 10.5 with PostGIS 2.4.4

Postgres.app runs on macOS 10.10 or later, but PostgreSQL 11 requires 10.12 or later.

The SHA 256 checksum of Postgres-2.2beta3.dmg is 1af388316adc12ddba395ef18e3783b74daf58ef1939850897fe570de0d6d68c

PostgresApp 2.2beta2 (with PostgreSQL 11beta4) - 2018-09-20 15:08:22

This is the latest pre-release build of Postgres.app with PostgreSQL 11 (Beta 4)

It includes the following versions of PostgreSQL:

  • PostgreSQL 11 Beta 4 with PostGIS 2.5.0rc2
    It does not include plv8. I'm still working on that.
    This build also includes support for Mapbox Vector Tiles (see #412)
  • PostgreSQL 9.5.14 with PostGIS 2.2.7
  • PostgreSQL 9.6.10 with PostGIS 2.3.7
  • PostgreSQL 10.5 with PostGIS 2.4.4

Postgres.app requires macOS 10.10 or later.

The SHA 256 checksum of Postgres-2.2beta2.dmg is 48e17cb960527eba5445f5595d81fdefd65bcf57541210a860a39484b7b3bf8b

Postgres.app 2.1.5 - 2018-08-09 13:33:12

This release of Postgres.app comes with the latest binaries from the PostgreSQL Quarterly Update August 2018.

Postgres.app 2.1.5 is the latest and greatest version of Postgres.app for Macs running macOS 10.10 or later. It includes three versions of PostgreSQL:

  • PostgreSQL 9.5.14 with PostGIS 2.2.7
  • PostgreSQL 9.6.10 with PostGIS 2.3.7
  • PostgreSQL 10.5 with PostGIS 2.4.4

The SHA 256 checksum of Postgres-2.1.5.dmg is 91296fa25ec45dd099f47d287a05ff07599b30aed4e6d665388b8a56f0b5cf8b

We've also included legacy versions for computers running macOS 10.7 or later.

PostgresApp 2.2beta (with PostgreSQL 11 Beta 1) - 2018-05-24 13:40:45

The latest build of Postgres.app with PostgreSQL 11 Beta 1

  • PostgreSQL 11 Beta 1 with PostGIS 2.5dev
    (currently without plv8. I'll try to include it in the next beta)
  • PostgreSQL 10.4 with PostGIS 2.4.4
  • PostgreSQL 9.6.9 with PostGIS 2.3.7
  • PostgreSQL 9.5.13 with PostGIS 2.2.7

Postgres.app requires macOS 10.10 or later.

The SHA 256 hash of the disk image is 21ddf269ad13221a42db7613ac829837bdf10f02945e21252c40ad4d05bb629e

Postgres.app 2.1.4 - 2018-05-10 09:10:02

This release of Postgres.app comes with the latest binaries from the PostgreSQL Quarterly Update May 2018.

Postgres.app 2.1.4 is the latest and greatest version of Postgres.app for Macs running macOS 10.10 or later. It includes three versions of PostgreSQL:

  • PostgreSQL 9.5.13 with PostGIS 2.2.7
  • PostgreSQL 9.6.9 with PostGIS 2.3.7
  • PostgreSQL 10.4 with PostGIS 2.4.4

We also include legacy versions of Postgres.app for computers running macOS 10.7 or later:

  • PostgreSQL 9.3.23 with PostGIS 2.1.9
  • PostgreSQL 9.4.18 with PostGIS 2.1.9
  • PostgreSQL 9.5.13 with PostGIS 2.2.7
  • PostgreSQL 9.6.9 with PostGIS 2.3.7
  • PostgreSQL 10.4 with PostGIS 2.4.4

Postgres.app Security Update March 2018 - 2018-03-01 13:24:53

These is an unscheduled security update which addresses the security vulnerability CVE-2018-1058.

Postgres.app 2.1.3 is the latest and greatest version of Postgres.app for Macs running macOS 10.10 or later. It includes three versions of PostgreSQL:

  • PostgreSQL 9.5.12 with PostGIS 2.2.6
  • PostgreSQL 9.6.8 with PostGIS 2.3.6
  • PostgreSQL 10.3 with PostGIS 2.4.3

We also include legacy versions of Postgres.app for computers running macOS 10.7 or later:

  • PostgreSQL 9.3.22 with PostGIS 2.1.9
  • PostgreSQL 9.4.17 with PostGIS 2.1.9
  • PostgreSQL 9.5.12 with PostGIS 2.2.6
  • PostgreSQL 9.6.8 with PostGIS 2.3.6
  • PostgreSQL 10.3 with PostGIS 2.4.3

Postgres 2.1.2 - 2018-02-14 16:47:59

Upgrade to the latest releases of PostgreSQL!

This is the latest and greatest version of Postgres.app for Macs running macOS 10.10 or later. It includes three versions of PostgreSQL:

  • PostgreSQL 10.2 (Release Notes) with PostGIS 2.4.3
  • PostgreSQL 9.6.7 (Release Notes) with PostGIS 2.3.6
  • PostgreSQL 9.5.11 (Release Notes) with PostGIS 2.2.6

The SHA-256 hash of the disk image is 3fca874dfb9472bee547b82a40b0b3cca3a20df07349bf166aea372dd4a633f8

Postgres.app Legacy 10.2 - 2018-02-14 16:45:54

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 10.2
  • PostGIS 2.4.3

Postgres.app Legacy 9.6.7 - 2018-02-14 16:45:46

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.6.7
  • PostGIS 2.3.6

Postgres.app Legacy 9.5.11 - 2018-02-14 16:45:37

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.5.11
  • PostGIS 2.2.6

Postgres.app Legacy 9.4.16 - 2018-02-14 16:45:28

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.4.16
  • PostGIS 2.1.9

Postgres.app Legacy 9.3.21 - 2018-02-14 16:45:19

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.3.21
  • PostGIS 2.1.9

Postgres.app 2.1.1 - 2017-11-09 15:11:48

Upgrade to the latest releases of PostgreSQL!

This is the latest and greatest version of Postgres.app for Macs running macOS 10.10 or later. It includes three versions of PostgreSQL:

  • PostgreSQL 10.1 (Release Notes) with PostGIS 2.4.1
  • PostgreSQL 9.6.6 (Release Notes) with PostGIS 2.3.4
  • PostgreSQL 9.5.10 (Release Notes) with PostGIS 2.2.6

The SHA-256 hash of the disk image is ac0656b522a58fd337931313f09509c09610c4a6078fe0b8e469e69af1e1750b

Postgres.app Legacy 10.1 - 2017-11-09 15:11:37

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 10.1
  • PostGIS 2.4.1

Postgres.app Legacy 9.6.6 - 2017-11-09 15:11:27

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.6.6
  • PostGIS 2.3.4

Postgres.app Legacy 9.5.10 - 2017-11-09 15:11:18

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.5.10
  • PostGIS 2.2.6

Postgres.app Legacy 9.4.15 - 2017-11-09 15:11:05

This is the legacy version of Postgres.app for computers running macOS 10.7 or later. This release has the old user interface and contains a single version of PostgreSQL. We provide this binary so users who don't want to upgrade their Mac can still use up to date versions of PostgreSQL.

This release contains:

  • PostgreSQL 9.4.15
  • PostGIS 2.1.9