PostgreSQL Tutorial: Install PostgreSQL on MacOS

July 31, 2023

Summary: in this tutorial, you will learn how to download the PostgreSQL, install PostgreSQL on macOS, and restore the sample database.

Download PostgreSQL installer for macOS

To download the PostgreSQL installer, you follow these steps:

Install PostgreSQL on macOS

To install PostgreSQL on macOS, you follow these steps:

First, launch the setup wizard by double-click the installer file:

img

Second, select the directory where the PostgreSQL will be installed and click the Next button:

img

Third, select the components that you want to install, uncheck the Stack Builder, and click the Next button:

img

Fourth, specify a directory where PostgreSQL stores the data and click the Next button:

img

Fifth, enter the password for the postgres user account. You should note down this password for logging in to the PostgreSQL database server later. After that, click the Next button.

img

Sixth, specify the port number on which the PostgreSQL server will listen. By default, PostgreSQL uses port number 5432.

img

Seventh, select the locale used by PostgreSQL. By default, PostgreSQL uses the locale of the current operating system:

img

Eighth, review the installation information. If everything looks correct, click the Next button to begin the installation.

img

Ninth, click the Next button to start installing the PostgreSQL database server on your computer:

img

It will take few mintues to complete the installation.

img

Finally, click the Finish button once the installation is completed:

img

Load the sample database

First, launch pgAdmin from Launchpad.

Second, enter the password for the postgres user.

Third, right-click the PostgreSQL 12 and select Create > Database.. to open a dialog for creating a new database.

img

Fourth, enter dvdrental as the database, postgres as the owner, and click the Save button to create the dvdrental database.

img

Sixth, download the sample database and unzip it. You’ll get a directory with many files.

Seventh, right-click the dvdrental database and select the Restore… menu item:

img

Eighth, select the directory as the Format (1), the directory that contains sample database as the Filename (2), and postgres as the Role name (3), and click the Restore button.

img

It will take few seconds to restore the sample database. Once the restoration completes, you will see a notification like this:

img

It means that you have successfully created the sample database and restored it from the downloaded file.

In this tutorial, you have learned how to download PostgreSQL installer for macOS, how to install PostgreSQL on macOS, and how to restore the sample database.