How to Install PostgreSQL on MacOS

Just a short list to show the ways to install Postgres on the Mac.

MacPorts

Homebrew

Postgres.app

Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac app. It includes everything you need to get started: we’ve even included popular extensions like PostGIS for geo data and plv8 for JavaScript.
Postgres.app has a beautiful user interface and a convenient menu bar item. You never need to touch the command line to use it – but of course we do include all the necessary command line tools and header files for advanced users.
Postgres.app can install minor updates automatically, so you get bug fixes as soon as possible.

Conda-forge

BigSQL

Postgres by BigSQL is complete. At its core, BigSQL is a PostgreSQL distribution. But in addition to the core PostgreSQL database, BigSQL is integrated with more than 20 open source projects that make it easier to do Postgres development, integration, scale-out, and management, as well as migrations from proprietary databases.

Postgres by BigSQL is developer-friendly. Unlike some Postgres distributions, BigSQL’s toolchain is 100% open source, with no commercial dependencies. Binaries are Relocatable. Installs and uninstalls happen cleanly.

http://bigsql.com/info/

Home Page

PostgreSQL is the default database on macOS Server as of OS X Server version 10.7. macOS without the macOS Server add-on installed includes only the PostgreSQL libpq shared library.
macOS Server 10.12 ships with PostgreSQL 9.4. Minor updates are provided by Apple, but not necessarily right after a new PostgreSQL minor release.
There are several other installers available for PostgreSQL on macOS, which is the recommended way to install.

https://www.postgresql.org/download/macosx/

2UDA–Big Data Analytics with Postgresql

2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, spreadsheets, data mining and visualisation in one seamless desktop installer. 

https://www.2ndquadrant.com/en/resources/2uda/

Docker

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.