How to Install PostgreSQL on MacOS

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

MacPorts

sudo port install postgresql11-server

Homebrew

brew install postgres

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

To install this package with conda run one of the following:
conda install -c conda-forge postgresql
conda install -c conda-forge/label/gcc7 postgresql
conda install -c conda-forge/label/broken postgresql
conda install -c conda-forge/label/cf201901 postgresql

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

docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres