The easiest way to get started with PostgreSQL on the Mac

Related tags

postgres postgis plv8
Overview

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 binaries for PostgreSQL 13 are built on macOS 10.15 with Xcode 11.7

  • the GUI is built on macOS 10.15 with Xcode 11.7

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 11 or later (Swift 5 support is required)

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 PostgreSQL 13 docs, you need these packages (see https://www.postgresql.org/docs/current/docguide-toolsets.html for details):

  • docbook-xml-4.5
  • docbook-xsl-nons
  • fop

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

sudo port -N install autoconf automake pkgconfig libtool docbook-xml-4.5 docbook-xsl-nons fop

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

Older versions required a different set of packages for building the docs, please see the specific versions of the documentation page https://www.postgresql.org/docs/current/docguide-toolsets.html for details.

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.

Issues
  • pg gem 0.15.1 + postgres.app 9.2.4 = more dylib issues

    pg gem 0.15.1 + postgres.app 9.2.4 = more dylib issues

    /Users/swrobel/.rvm/gems/[email protected]/gems/polyglot-0.3.3/lib/polyglot.rb:63:in `require': dlopen(/Users/swrobel/.rvm/gems/[email protected]/gems/pg-0.15.1/lib/pg_ext.bundle, 9): Library not loaded: @executable_path/../lib/libssl.1.0.0.dylib (LoadError)
      Referenced from: /Applications/Postgres.app/Contents/MacOS/lib/libpq.dylib
      Reason: image not found - /Users/swrobel/.rvm/gems/[email protected]/gems/pg-0.15.1/lib/pg_ext.bundle
    

    I've tried both gem install pg and gem install pg -- --with-pg-config=/Applications/Postgres.app/Contents/MacOS/bin/pg_config and both lead to the same result.

    Anyone else seeing this? I'd like to revert to 9.2.2 but I can't find a download link...

    opened by swrobel 76
  • Could not start on port 5432

    Could not start on port 5432

    I can't get Postgres Version 9.3.5.0 to start - I get the following error:

    Could not start on port 5432

    I followed issue #152, and still am having trouble.

    Following the troubleshooting, I'm getting:

    LOG:  could not translate host name "localhost", service "5432" to address: nodename nor servname provided, or not known
    WARNING:  could not create listen socket for "localhost"
    FATAL:  could not create any TCP/IP sockets
    

    nslookup localhost shows:

    Server:     10.0.1.1
    Address:    10.0.1.1#53
    
    Non-authoritative answer:
    Name:   localhost
    Address: 127.0.0.1
    

    /etc/hosts shows:

    ##
    # Host Database
    #
    # localhost is used to configure the loopback interface
    # when the system is booting.  Do not change this entry.
    ##
    127.0.0.1   localhost
    255.255.255.255 broadcasthost
    ::1             localhost 
    fe80::1%lo0 localhost
    

    Any ideas?

    opened by idigit 34
  • Unspecified version of PLV8

    Unspecified version of PLV8

    The build doesn't set a specific version of PLV8 but just picks the latest one which is potentially unstable. This also means it could suddenly break compatibility with a given version of postgres.

    I just hit an issue where I'm not sure which build of PLV8 I'm actually using because it depends on what time the build was made for the binary distribution.

    opened by alexandertakacs 26
  • Could not start on port 5432

    Could not start on port 5432

    A colleague get this on a freshly installed 10.9 computer using 9.3.1.1 RC 1.

    The Library/Application Support/Postgres93 folder is empty and there is a crash-log[1]. Any suggestions?

    [1] http://paste2.org/fUvpttJj

    opened by ottob 24
  • Unable to open psql on Mavericks

    Unable to open psql on Mavericks

    When running version 9.3.0.0 on Mavericks GM, trying to open psql from the menu option gives the following error:

    “psql” can’t be opened because Postgres is not allowed to open documents in Terminal.

    Manually running psql from inside the app container does work.

    bug 
    opened by mcmillion 24
  • Support for iTerm

    Support for iTerm

    It would be very nice if PostgresApp supported iTerm. If you don't want to have a Preference pane, you could just check for iTerm and use it if it's available.

    opened by brandondrew 23
  • Switching from Homebrew to Postgres.app, and can't connect

    Switching from Homebrew to Postgres.app, and can't connect

    I just recently switched from my Homebrew installation (which was a bit of a pain to manage) to PostgresApp. For some reason, it seems to be trying to connect to homebrew's binary.

    $ psql
    psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    

    and if I try and specify the host:

    $ psql -h localhost
    psql: could not connect to server: Connection refused
        Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 5432?
    could not connect to server: Connection refused
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 5432?
    could not connect to server: Connection refused
        Is the server running on host "localhost" (fe80::1) and accepting
        TCP/IP connections on port 5432?
    

    And yes, it is attempting to use the right binary.

    $ which psql
    /Applications/Postgres.app/Contents/MacOS/bin/psql
    

    I really need this to work, so any help would be greatly appreciated!

    opened by mdespuits 22
  • ERROR:  could not access file

    ERROR: could not access file "$libdir/plpgsql": No such file or directory

    Great App for development! I'm pumped to use it, but I am getting the following error when trying to create a stored procedure.

    #CREATE FUNCTION
    #...
    #END;
    #$$ LANGUAGE plpgsql;
    ERROR:  could not access file "$libdir/plpgsql": No such file or directory
    

    Any idea what might be wrong? Or how I can fix it?

    I checked...

    $ pg_config --pkglibdir
    /Applications/Postgres.app/Contents/MacOS/lib
    
    $ pg_config --libdir
    /Applications/Postgres.app/Contents/MacOS/lib
    

    I've confirmed that plpgsql.so is in that directory.

    Should have mentioned that my version is reported as Version 9.2.2.0 (20). I just downloaded it a few days ago.

    opened by croxey 21
  • psql: could not connect to server: Connection refused

    psql: could not connect to server: Connection refused

    Hello,

    I'm trying to run Postgress.app on Moutain Lion (don't know if it matters) but I'm getting this error:

    [~] ➔ psql -h localhost psql: could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (fe80::1) and accepting TCP/IP connections on port 5432?

    The elephant icon on the menu bar says it is running on port 5432. I've looked into ~/Library/Containers and the directory com.heroku.Postgres isn't there.

    Looking in the Console.app I found this just after I open Postgress.app:

    24/07/12 12:27:45,398 Postgres[26507]: Could not connect the action selectPostgresStatus: to target of class AppDelegate 24/07/12 12:27:45,551 Postgres[26507]: 26509 /Applications/Postgres.app/Contents/MacOS/bin/pg_ctl: Status 0

    Any ideas how to solve? Any places where I can get more information about the problem, logs?

    opened by fcy 21
  • Could not start on port 5432 - update documentation with fix

    Could not start on port 5432 - update documentation with fix

    There is no logging or console output when trying to start postgres which made it hard to debug this problem.

    I tried this by chance and it fixed the problem.

    sudo sysctl -w kern.sysv.shmall=65536
    sudo sysctl -w kern.sysv.shmmax=16777216
    

    It's a common problem with postgres on OSX and should be added to the docs.

    Or the location of the log file should be specified and if this error occurs then the user should be directed to check here first.

    opened by vjpr 20
  • Makefile.global

    Makefile.global

    Having downloaded the latest Postgres App I've spent a while trying to build the PL/lua extension on macOS Big Sur. The build initially failed because it was trying to link using /Applications/Xcode-11.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld. In later versions of the Xcode command line tools, it should now (at least on my system) be Applications/Xcode/Contents/Developer/usr/bin/ld.

    I finally tracked the hard coded path to a setting for LD in /Applications/Postgres.app/Contents/Versions/13/lib/postgresql/pgxs/src/Makefile.global. Editing it works fine, but noting the comments that the file is created by the configure script -- which I couldn't find -- and that should any edits be needed it is a bug, I thought I should let you know.

    Thanks for maintaining Postgres App!

    opened by GaiusScotius 0
  • Please add locale support when initting the database

    Please add locale support when initting the database

    • Locale can be specified when creating a database server with
    init-db --locale=<locale>
    
    • The locale for the macOs logged-in user can be read with a call to:
    /usr/bin/locale
    
    • All available locales can be listed with locale -a
    opened by chrisfcarroll 4
  • Include development tools in custom variants

    Include development tools in custom variants

    I am trying to make and install quantile as an extension into Postgres 13 but I do not have access to the postgres development tools that are needed for this. Could you in the future create a version that supports this as an option?

    opened by stenerikbjorling 1
  • A non-fatal error occur whilst creating menu shortcuts.

    A non-fatal error occur whilst creating menu shortcuts.

    Getting this error while trying to install different postgresql versions to my mac (running big sur)

    opened by atayardimci 1
  • Adding a JS 'how to connect'

    Adding a JS 'how to connect'

    using node

    • [x] npm install pg
    const { Client } = require('pg');
    
    var connectionString = "postgres://{user}:{password}@localhost:5432/{database}";
    
    
    
    const client = new Client
    (
    	{
    		connectionString: connectionString
    	}
    );
    
    client.connect();
    
    

    to run

    -[ ] node {whatever your_file_name_is}

    opened by quinwoods 3
  • Feature request: Compile in support for plprofiler

    Feature request: Compile in support for plprofiler

    I recently discovered that Postgres.app now includes support for pldebugger. Adding plprofiler would be a great compliment to that.

    https://github.com/bigsql/plprofiler

    opened by morrisdeoryx 0
  • \COPY Table_Name FROM '/Absolute/File/Path/File.csv' DELIMITER ',' CSV HEADER; Error

    \COPY Table_Name FROM '/Absolute/File/Path/File.csv' DELIMITER ',' CSV HEADER; Error

    I'm trying to set up some co workers on the app so we can qy tables from large CSV files. Unfortunately my coworkers are getting an error saying the File or Directory does not exist.

    How can I update this?

    Here is an example of what is producing that error: \COPY Table_Name FROM '/Absolute/File/Path/File.csv' DELIMITER ',' CSV HEADER;

    opened by tlrcorbin 0
  • "ERROR: could not open temporary file" after upgrade to Mac OS Big Sur

    After upgrading to Mac OS Big Sur I am frequently plagued by errors with temporary file access:

    $ pg_restore -d dbname --role username --no-password dbname-2021-01-21-0820.dump
    pg_restore: while PROCESSING TOC:
    pg_restore: from TOC entry 6072; 2606 2882021 CONSTRAINT products products_pkey username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.72.sharedfileset/0.0": Interrupted system call
    Command was: ALTER TABLE ONLY public.products
        ADD CONSTRAINT products_pkey PRIMARY KEY (id);
    
    
    pg_restore: from TOC entry 5224; 1259 2882242 INDEX address_verified_by_id username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.100.sharedfileset/0.0": Interrupted system call
    Command was: CREATE INDEX address_verified_by_id ON public.address USING btree (verified_by_id);
    
    
    pg_restore: from TOC entry 5739; 1259 2882465 INDEX orderline_order_id username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.144.sharedfileset/0.0": Interrupted system call
    Command was: CREATE INDEX orderline_order_id ON public.orderline USING btree (order_id);
    
    
    pg_restore: from TOC entry 5745; 1259 2882469 INDEX orderlinehistory_changed_by_id username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.148.sharedfileset/0.0": Interrupted system call
    Command was: CREATE INDEX orderlinehistory_changed_by_id ON public.orderlinehistory USING btree (changed_by_id);
    
    
    pg_restore: from TOC entry 5769; 1259 2882480 INDEX payment_cancelled_by_id username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.159.sharedfileset/0.0": Interrupted system call
    Command was: CREATE INDEX payment_cancelled_by_id ON public.payment USING btree (cancelled_by_id);
    
    
    pg_restore: from TOC entry 5844; 1259 2882515 INDEX paymentnotification_69dfcb07 username
    pg_restore: error: could not execute query: ERROR:  could not open temporary file "base/pgsql_tmp/pgsql_tmp80511.176.sharedfileset/0.0": Interrupted system call
    Command was: CREATE INDEX paymentnotification_69dfcb07 ON public.paymentnotification USING btree (order_id);
    
    
    pg_restore: warning: errors ignored on restore: 6
    

    These errors happen consistently when using pg_restore, but also happen when executing queries that trigger parallel gathers:

    2021-01-21 10:59:25.861 GMT [96073] ERROR:  could not create temporary file "base/pgsql_tmp/pgsql_tmp96073.0.sharedfileset/i15of64.p0.0": Interrupted system call
    2021-01-21 10:59:25.861 GMT [96073] STATEMENT:  SELECT [REDACTED]
    2021-01-21 10:59:25.862 GMT [96075] FATAL:  could not open file "global/pg_filenode.map": Interrupted system call
    2021-01-21 10:59:25.863 GMT [78868] LOG:  background worker "parallel worker" (PID 96075) exited with exit code 1
    2021-01-21 10:59:25.864 GMT [96074] FATAL:  terminating connection due to administrator command
    2021-01-21 10:59:25.865 GMT [78868] LOG:  background worker "parallel worker" (PID 96074) exited with exit code 1
    

    If I set max_parallel_workers = 1 in my postgresql.conf those queries succeed. I'm guessing that's just because they no longer need to use temporary files.

    I have replicated this with a completely fresh install of Version 2.4.1 (100) using both Postgresql 12 and 13. I also have a colleague with exactly the same issue on slightly older Mac hardware.

    Here are the permissions of my Postgresql instance's base directory:

    total 0
    drwx------     9 adamforster  staff    288 21 Jan 09:43 .
    drwx------    27 adamforster  staff    864 21 Jan 11:03 ..
    drwx------   291 adamforster  staff   9312 14 Dec 15:09 1
    drwx------  2558 adamforster  staff  81856 21 Jan 11:03 103949
    drwx------   291 adamforster  staff   9312 14 Dec 15:09 13706
    drwx------   292 adamforster  staff   9344 21 Jan 11:04 13707
    drwx------   292 adamforster  staff   9344 21 Jan 11:03 16385
    drwx------   291 adamforster  staff   9312 21 Jan 08:37 16388
    drwx------     2 adamforster  staff     64 21 Jan 11:13 pgsql_tmp
    

    I'm going to completely uninstall Postgres.app and see if I get the same issues with a homebrew install of postgresql. I'll update this issue with the results.

    opened by adamjforster 34
  • Error message: Not running

    Error message: Not running

    I cannot start the app: the error "Not running" appears.

    Bildschirmfoto 2021-01-15 um 13 08 55

    The server log looks like this:

    Bildschirmfoto 2021-01-15 um 13 09 21

    I have uninstalled and re-installed everything but this does not help.

    How can I fix this?

    opened by DataMower 1
  • No History Search Support in psql

    No History Search Support in psql

    I am not sure how you compile but every time I have compiled PG myself against the built-in libraries, I always get readline history support with CTRL-R. Version 2.4.1 on Mac OS 10.15.7.

    opened by aksuska 5
Releases(v2.4.3)
  • v2.4.3(May 19, 2021)

  • v2.5beta1(Apr 30, 2021)

    This is the first beta release of Psotgres.app with binaries for ARM.

    It also includes a patch to fix an issue on Big Sur with some security products (#610)

    The GUI app is still built for Intel, but it runs fine with Rosetta.

    We include two versions of the PostgreSQL Server binaries:

    • 13: PostgreSQL 13.2 built for Intel . This is the same as the previous version except for a patch that attempts to fix issue #610. It includes all the usual extras like PostGIS and plv8.
    • 13-arm: PostgreSQL 13.2 built for ARM. This includes PostgreSQL only. PostGIS and plv8 are not included.

    To run the ARM version, you need an M1 Mac, and you need to create a new server:

    1. Open Postgres.app and click the button to show the sidebar
    2. Click the "+" button to add a server
    3. Select "13-arm" as the server version
    4. Click done, then click "Initialize"

    To use the ARM version of the command line tools, please make sure the $PATH is set up correctly. which psql should return /Applications/Postgres.app/Contents/Versions/13-arm/psql. Please adjust the PATH in /etc/paths.d/postgresapp (or wherever else you configured it)

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.5beta1-13-13-arm.dmg(91.74 MB)
  • v2.4(Sep 24, 2020)

    PostgreSQL 13 is released today!

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

    Postgres-2.4-13.dmg includes just PostgreSQL 13.0 with PostGIS 3.1.0alpha2, PL/v8 2.3.15 and PL/Python 3.8 (requires Python 3.8 from python.org).

    Postgres-2.4-9.5-9.6-10-11-12-13.dmg includes all currently supported versions of PostgreSQL (PostgreSQL 9.5.x - 13.x).

    The remaining downloads are updates for older versions of PostgreSQL.

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

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.4-13.dmg(63.33 MB)
    Postgres-2.4-9.5-9.6-10-11-12-13.dmg(306.45 MB)
    Postgres-2.4-11.dmg(64.74 MB)
    Postgres-2.4-12.dmg(62.30 MB)
  • v2.3.5c(Jun 25, 2020)

    This version of Postgres.app includes all currently supported versions of PostgreSQL (9.5-12) and the second beta of PostgreSQL 13.

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

    • comes with PostgreSQL 13beta2 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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.5c-9.5-9.6-10-11-12-13.dmg(298.53 MB)
  • v2.3.5b(May 21, 2020)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.5b-9.5-9.6-10-11-12-13.dmg(298.52 MB)
  • v2.3.5(May 14, 2020)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.5-9.5-9.6-10-11.dmg(197.51 MB)
    Postgres-2.3.5-9.5-9.6-10.dmg(141.55 MB)
    Postgres-2.3.5-11.dmg(64.85 MB)
    Postgres-2.3.5-10-11-12.dmg(174.19 MB)
    Postgres-2.3.5-9.4-9.5-9.6-10-11-12.dmg(284.71 MB)
    Postgres-2.3.5-12.dmg(62.40 MB)
  • v2.3.3e(Jan 25, 2020)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.3e-9.4-9.5-9.6-10-11-12.dmg(296.95 MB)
    Postgres-2.3.3e-10-11-12.dmg(177.12 MB)
    Postgres-2.3.3e-12.dmg(62.35 MB)
  • v2.3.3c(Dec 11, 2019)

  • v2.3.2(Nov 14, 2019)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.2-12.dmg(65.68 MB)
    Postgres-2.3.2-10-11-12.dmg(183.89 MB)
    Postgres-2.3.2-9.4-9.5-9.6-10-11-12.dmg(303.72 MB)
    Postgres-2.3.2-9.5-9.6-10.dmg(151.70 MB)
    Postgres-2.3.2-9.5-9.6-10-11.dmg(210.36 MB)
    Postgres-2.3.2-11.dmg(67.58 MB)
  • v2.3.1(Oct 17, 2019)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3.1-9.5-9.6-10-11-12.dmg(266.71 MB)
    Postgres-2.3.1-10-11-12.dmg(183.52 MB)
    Postgres-2.3.1-12.dmg(65.64 MB)
  • v2.3(Oct 3, 2019)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3-10-11-12.dmg(181.82 MB)
    Postgres-2.3-12.dmg(64.66 MB)
  • v2.2.5(Aug 8, 2019)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3beta3.dmg(185.06 MB)
    Postgres-2.2.5-11.dmg(66.90 MB)
    Postgres-2.2.5-9.5-9.6-10-11.dmg(208.38 MB)
    Postgres-2.1.9.dmg(150.46 MB)
    Postgres-Legacy-10.10.zip(62.60 MB)
    Postgres-Legacy-9.6.15.zip(47.50 MB)
    Postgres-Legacy-9.5.19.zip(42.70 MB)
    Postgres-Legacy-9.4.24.zip(40.00 MB)
  • v2.2.4(Jun 20, 2019)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-Legacy-9.4.23.zip(40.00 MB)
    Postgres-Legacy-9.5.18.zip(42.70 MB)
    Postgres-Legacy-9.6.14.zip(47.50 MB)
    Postgres-Legacy-10.9.zip(62.59 MB)
    Postgres-2.1.8.dmg(150.47 MB)
    Postgres-2.2.4-11.dmg(66.89 MB)
    Postgres-2.2.4-9.5-9.6-10-11.dmg(208.37 MB)
    Postgres-2.3beta2.dmg(180.10 MB)
  • v2.3beta1(May 23, 2019)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.3beta1.dmg(179.98 MB)
  • v2.2.3(May 9, 2019)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2.3-11.dmg(66.88 MB)
    Postgres-Legacy-9.4.22.zip(40.00 MB)
    Postgres-Legacy-9.5.17.zip(42.70 MB)
    Postgres-Legacy-9.6.13.zip(47.49 MB)
    Postgres-Legacy-10.8.zip(62.58 MB)
    Postgres-2.2.3-9.5-9.6-10-11.dmg(208.34 MB)
    Postgres-2.1.7.dmg(150.45 MB)
  • v2.2.2(Feb 14, 2019)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2.2-11.dmg(66.85 MB)
    Postgres-2.2.2-9.5-9.6-10-11.dmg(207.18 MB)
    Postgres-Legacy-9.4.21.zip(39.99 MB)
    Postgres-Legacy-9.5.16.zip(42.68 MB)
    Postgres-Legacy-9.6.12.zip(47.05 MB)
    Postgres-Legacy-10.7.zip(61.92 MB)
    Postgres-2.1.6.dmg(149.36 MB)
  • v2.2(Oct 18, 2018)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2-11.dmg(67.88 MB)
    Postgres-2.2-9.5-9.6-10-11.dmg(210.04 MB)
  • v2.2beta3(Sep 24, 2018)

    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

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2beta3.dmg(206.21 MB)
  • v2.2beta2(Sep 20, 2018)

    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

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2beta2.dmg(206.24 MB)
  • v2.1.5(Aug 9, 2018)

    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.

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.1.5.dmg(150.80 MB)
    Postgres-Legacy-9.5.14.zip(44.02 MB)
    Postgres-Legacy-9.6.10.zip(48.23 MB)
    Postgres-Legacy-10.5.zip(62.76 MB)
  • v2.2beta1(May 24, 2018)

    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

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.2beta.dmg(203.61 MB)
  • v2.1.4(May 10, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-Legacy-9.3.23.zip(40.50 MB)
    Postgres-Legacy-9.4.18.zip(41.15 MB)
    Postgres-Legacy-9.5.13.zip(43.99 MB)
    Postgres-Legacy-9.6.9.zip(48.20 MB)
    Postgres-Legacy-10.4.zip(62.72 MB)
    Postgres-2.1.4.dmg(150.73 MB)
  • v2.1.3(Mar 1, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-Legacy-9.4.17.zip(41.14 MB)
    Postgres-Legacy-9.5.12.zip(43.54 MB)
    Postgres-Legacy-9.6.8.zip(47.74 MB)
    Postgres-Legacy-10.3.zip(61.79 MB)
    Postgres-2.1.3.dmg(148.97 MB)
    Postgres-Legacy-9.3.22.zip(40.49 MB)
  • v2.1.2(Feb 14, 2018)

    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

    Source code(tar.gz)
    Source code(zip)
    Postgres-2.1.2.dmg(148.85 MB)
  • 10.2(Feb 14, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-10.2.zip(61.75 MB)
  • 9.6.7(Feb 14, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-9.6.7.zip(47.69 MB)
  • 9.5.11(Feb 14, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-9.5.11.zip(43.48 MB)
  • 9.4.16(Feb 14, 2018)

    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
    Source code(tar.gz)
    Source code(zip)
    Postgres-9.4.16.zip(41.08 MB)
Owner
Postgres.app
The easiest way to get started with PostgreSQL on the Mac
Postgres.app
OS X and iOS application and framework to play with the Apple Push Notification service (APNs)

Pusher OS X and iOS application and framework to play with the Apple Push Notification service (APNs) Installation Install the Mac app using Homebrew

noodlewerk 6.1k Jul 29, 2021
The easiest way to install and switch between multiple versions of Xcode - with a mouse click.

Xcodes.app The easiest way to install and switch between multiple versions of Xcode. If you're looking for a command-line version of Xcodes.app, try x

Robots and Pencils 1.2k Aug 5, 2021
The Git interface you've been missing all your life has finally arrived.

GitUp Work quickly, safely, and without headaches. The Git interface you've been missing all your life has finally arrived. Git recently celebrated it

GitUp 9.8k Jul 31, 2021
Use the Touch Bar on any Mac

Touch Bar Simulator Use the Touch Bar on any Mac Launch the Touch Bar simulator from anywhere without needing to have Xcode installed, whereas Apple r

Sindre Sorhus 1.5k Aug 4, 2021
MySQL/MariaDB database management for macOS

Sequel Ace Sequel Ace is the "sequel" to longtime macOS tool Sequel Pro. Sequel Ace is a fast, easy-to-use Mac database management application for wor

Sequel-Ace 3.4k Aug 5, 2021
A free, native Apple macOS app for testing HTTP/REST endpoints

About CocoaRestClient is a Mac OS X app for testing HTTP/Restful endpoints. I love curl, but sometimes I need my output XML or JSON pretty printed. I

Mike Mattozzi 2.2k Aug 2, 2021
MySQL/MariaDB database management for macOS

Sequel Pro Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL & MariaDB databases. You can find more details

Sequel Pro 8.4k Aug 1, 2021
A scriptable scratchpad for developers. In slow yet steady progress.

Boop. Website • Download from GitHub • Get on the Mac App Store Documentation • Find more scripts How to get Boop There are four ways to get Boop. You

Ivan Mathy 2.1k Jul 25, 2021
GUI image optimizer for Mac

ImageOptim ImageOptim is a GUI for lossless image optimization tools: Zopfli, PNGOUT, OxiPNG, AdvPNG, PNGCrush, JPEGOptim, Jpegtran, Guetzli, Gifsicle

ImageOptim 7.2k Jul 24, 2021
A simple but highly customizable `UICollectionViewLayout` for `UICollectionView`.

CollectionViewPagingLayout Layout Designer SnapshotTransformView ScaleTransformView StackTransformView Custom implementations About This is a simple b

Amir Khorsandi 1.3k Aug 4, 2021
a Cocoa GUI for /etc/hosts

Hosts, a system preference pane to manage your hosts file Hosts adds a preference pane to your system preferences which lets you toggle your host file

Voxin Muyli 1.5k Aug 3, 2021
A macOS app which helps you manage dependency releases in your Podfile.

Pods Updater Why this app? I believe it should be up to the developer to determine the exact versions of dependencies used in their projects. When add

Kizito Nwose 516 Jul 23, 2021
Apache NetBeans

Apache NetBeans Apache NetBeans is an open source development environment, tooling platform, and application framework. Build status GitHub actions Tr

The Apache Software Foundation 1.6k Aug 4, 2021
MQTT X - Elegant Cross-platform MQTT 5.0 Desktop Client

MQTT X English | 简体中文 | 日本語 MQTT X is a cross-platform MQTT 5.0 client tool open sourced by EMQ, which can run on macOS, Linux and Windows, and suppor

Scalable Enterprise MQTT Broker 1.2k Aug 5, 2021