How To Install Psql On Mac

Summary: in this tutorial, yous 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, yous follow these steps:

• First, visit the PostgreSQL installer download folio.
• Then, download the PostgreSQL for macOS.

Install PostgreSQL on macOS

To install PostgreSQL on macOS, you follow these steps:

First, launch the setup magician past double-click the installer file:

Second, select the directory where the PostgreSQL will exist installed and click the Side by side button:

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

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

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

6th, specify the port number on which the PostgreSQL server will heed. Past default, PostgreSQL uses port number 5432.

Seventh, select the locale used by PostgreSQL. Past default, PostgreSQL uses the locale of the current operating arrangement:

Eighth, review the installation data. If everything looks correct, click the Next push to brainstorm the installation.

Ninth, click the Side by side button to outset installing the PostgreSQL database server on your computer:

It volition take few mintues to complete the installation.

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

Load the sample database

Showtime, launch pgAdmin from Launchpad.

Second, enter the countersign for the postgres user.

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

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

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

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

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

Information technology will take few seconds to restore the sample database. One time the restoration completes, you will see a notification like this:

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

In this tutorial, y'all take learned how to download PostgreSQL installer for macOS, how to install PostgreSQL on macOS, and how to restore the sample database.

Was this tutorial helpful ?

Source: https://www.postgresqltutorial.com/install-postgresql-macos/

Posted by: madrigalhiscon.blogspot.com

Share this post