Posts Learn Components Snippets Categories Tags About
/

Installing PostgreSQL on MacOS

Learn how to set up / install PostgreSQL on MacOS the easy way

3 months ago

8 mins read

71 views

There are several ways to install PostgreSQL on macOS and in this tutorial, you'll learn the easy way. 

Method 1: Installing PostgreSQL via DBngin


The first way is to install it using DBngin and it's a free all-in-one database version management tool that comes with other databases as well such as MySQL and Redis. Under the hood, it's using Homebrew and the setup process is very simple. DBngin comes with a very simple GUI and anything from creating, starting, and stopping the database server can be done with a simple one-click button.
DBngin Interface
To create a new database simply press the + button and fill in the details required.
DBngin Create new Database

What makes it special is the simple interface, simple database versioning, one press starting and stopping server and future updates right in one app.

Method 2: Installing PostgreSQL via Homebrew


The second method is to use the Homebrew package manager. Let's get started and first launch your terminal and run the command below one by one.
Update brew to get the latest package version from the source.
brew update
Run brew doctor to run diagnosis to check if there are any errors.
brew doctor
Install the latest version of PostgreSQL.
brew install postgresql
Starting the PostgreSQL server.
brew services start postgresql
If you want to stop then run the stop command.
brew services stop postgresql
Lastly, to view any running services run the services command.
brew services list
Do note that the command above installs the latest version of the database, if you want other versions you have to specify the version number. For example, if you want to install version 12 run the command like below.
brew install [email protected] 

Method 3: Installing PostgreSQL via Postgres.app


The 3rd method is to use Postgres.app and this application works just like DBngin but only has PostgreSQL database. It comes with a simple user interface and you can start, stop, restart, update and perform other actions with a click of a button. Do give it a look and if you are interested to try, just visit the homepage since it provides very straightforward installation guides.

Method 4: Installing PostgreSQL via Package Installer


The last method is to install it using the official package installer from PostgreSQL page. To get started just follow along with the installation wizard and you will have it installed in no time. It also comes with pgAdmin which is a database management tool that is quite handy to use.
Official PostgreSQL download page

By now you should have PostgreSQL installed on your macOS and if you come across any issue do start a new discussion below. Thanks for reading and if you find it helpful do share it with your friends.

Load comments for Installing PostgreSQL on MacOS

new

PostSrc Code Snippets

Learn new snippets today, level up your Laravel, Alpine JS, Vue JS, Tailwind CSS skills and more.

Learn New Snippets

Authored by

PostSrc poster

PostSrc

Full stack developer mainly focusing on the front end side of the web. The main author of PostSrc and loves writing tutorial and guides online.

new

PostSrc Code Components

Collection of Tailwind CSS components for everyone to use. Browse all of the components that's right for your project.

View Components