This post provides a step-by-step guide with a list of commands on how to install PostgreSQL on macOS using Homebrew. PostgreSQL, often simply Postgres, is an object-relational database management system with an emphasis on extensibility and standards compliance.
What is PostgreSQL?
“PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users. PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability.” ~ Wikipedia
What is Homebrew?
Homebrew is a free and open-source software package management system that simplifies the installation of software on Apple’s macOS operating system. It is known as the missing package manager for macOS.
The following is the single command required to install PostgreSQL on macOS using Homebrew.
$ brew install postgresql
This section provides a quick set of commands on how to install PostgreSQL on macOS using Homebrew. It is assumed that Homebrew is already installed. If not, please follow this link.
Congratulations! You have successfully installed PostgreSQL on macOS making use of Homebrew. Follow me on any of the different social media platforms and feel free to leave comments.