How To Install PostgreSQL on macOS

Many modern applications require a database to store information.  PostgreSQL is one of the most popular database systems available today.  In this guide, we'll walk you through how to install Postgres on your macOS(X) machine.

Download the PostgreSQL Graphical Installer

If you do not already use Brew or Macports, you can download the Postgres graphical installer here.

Once you've downloaded the .dmg file and clicked "Open," you will see the installer in its own window.

Note: You may need to allow your Mac to open software downloaded from the internet by clicking "Allow" when prompted.

Run the Install Process

During the installation process, you will be prompted to select components that you want to install.  You will definitely need the PostgreSQL Server and Command Line Tools. The other two are optional—pgAdmin 4 is the built-in client (but we will be using Arctype), and Stack Builder is a commercial software bundle.

Complete the Install Process

As the install proceeds, you will see a default system user created and probably be prompted for a password. This is the postgres user, and it is important to remember the password you chose. To complete the install, you can close the installer.

Check your Local Postgres on Mac

Check that the local database is running by connecting to it using the host Localhost (port 5432), the postgres user, and the password you supplied during the install process.  If you have not already created your own database, you can use the default postgres database.  Click Test Connection to verify that your install worked!

Using an SQL Client with PostgreSQL

Now that you’ve installed Postgres on your Mac, you may need to add or edit data. We recommend using an SQL client to do so. Check out our guide for setting up Postgres with Arctype in this tutorial.