The easiest way to get started with PostgreSQL on the Mac
Alternatives To Postgresapp
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
11 days ago132otherMakefile
The easiest way to get started with PostgreSQL on the Mac
a year ago9February 26, 202118otherGo
Your persistence layer for FHIR data
Aws Lambda Swift Sprinter67
3 years ago2apache-2.0Makefile
AWS Lambda Custom Runtime for Swift with swift-nio 2.0 support
Aiogram Peewee Template41
3 months agoPython
Telegram Bot API template, with aiogram, peewee and docker
Docker Symfony36
14 years ago4November 14, 2018mitMakefile
:whale: Environment for a Symfony application using Docker.
20 days ago3C++
Template of a C++ service that uses userver framework with PostgreSQL. Build, test and CI scripts ready
7 months agomitMakefile
Run dev environments easily and fastly using docker
Camptocamp Rancher Catalog30
3 years ago1apache-2.0Makefile
Camptocamp's Rancher Catalog
Fedora Coreos Matrix19
2 years ago2mitMakefile
Butane config to host a Matrix homeserver on Fedora CoreOS (nginx + Let's Encrypt + Synapse + PostgreSQL + element-web)
Docker Pgbackrest18
8 days agomitMakefile
pgBackRest inside Docker.
Alternatives To Postgresapp
Select To Compare

Alternative Project Comparisons

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


You can download recent versions of from the website.

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


Documentation is available at, as well as from the "Open Documentation" menu item in

What's Included?

How To Build consists of separate parts:

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

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

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

  • the binaries for PostgreSQL 9.4 - 10 were / 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 binaries for PostgreSQL 14 are built on macOS 11 with Command Line Tools for Xcode 12.5

  • the binaries for PostgreSQL 15 are built on macOS 12 with Command Line Tools for Xcode 14

  • the GUI is built on macOS 12 with Xcode 14.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 just copies the binaries from /Applications/

So just make sure you have a copy of 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-xx 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, wal2json, pldebugger and plv8 (till PostgreSQL 13). PostGIS and especially plv8 with all their dependencies 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/ (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)
  • Python from in version 3.8.x (PostgreSQL 13), 3.9.x (PostgreSQL 14) or 3.11.x (PostgreSQL 15)

For building PostGIS, you also need

  • autoconf
  • automake
  • pkgconfig (when building GDAL 3.0.0 or later)
  • libtool
  • cmake (when building universal binaries - PostgreSQL 14 or later)

By default, PostgreSQL is built with documentation. To build the PostgreSQL 13 docs, you need these packages (see 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 for details.

It is also possible to install those using homebrew, at least for PostgreSQL 14 and later:

brew install automake cmake docbook-xsl libtool pkg-config    

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

  • Initialise a database cluster: initdb -D DATA_DIRECTORY -U postgres --encoding=UTF-8 --locale=en_US.UTF-8. Starting with PostgreSQL 15 additionally: --locale-provider=icu --icu-locale=en-US --data-checksums
  • Start the server: pg_ctl start -D DATA_DIRECTORY --wait --log=DATA_DIRECTORY/postgres-server.log --options="-p PORT"
  • Create a superuser: createuser -U postgres -p PORT --superuser USERNAME
  • Create a user database: createdb USERNAME

On subsequent app launches, only starts the server.

The default DATA_DIRECTORY is /Users/USERNAME/Library/Application Support/Postgres/var-xx

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

When you stop a server the following command is performed. The same happens for all running servers if quit using the menubar icon:

  • pg_ctl stop --mode=fast --wait -D DATA_DIRECTORY

Command Line Utilities 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 pl/pgsql 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:


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.


If you find a bug, please open an issue. is maintained by Jakob Egger and Tobias Bussmann.

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

Popular Postgresql Projects
Popular Makefile Projects
Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.