SQL ET POSTGRE 2.3 : Installation PostgreSQL for Mac

In this video we install PostgreSQL on macOS. If you are on Windows, a separate video covers that case. Open your favourite search engine and type "postgresql". Click on the first link to reach the official PostgreSQL website, then simply click on Download. Under "Packages and Installers", select your operating system — here macOS. Use the "Download the installer" link and pick the latest version (at the time of recording, 13.2). Choose macOS once again and the download starts.

Running the installer

Once the file is downloaded, launch the installer and click Next. Choose the installation directory — leave the default if you have no specific preference. Accept the licence, accept the next screen too, then set a password. This password is the one you will use to connect to PostgreSQL, so remember it. Pick the default port that is suggested, click Next again, and start the installation. It takes a few moments. When the Stack Builder option appears at the end, untick it and finish the installer.
  • Download the installer from postgresql.org.
  • Set a strong password — you will be asked for it often.
  • Leave the default port unless you have a reason to change it.
  • Open pgAdmin to manage the server.
Look for pgAdmin in your Applications and launch it. PostgreSQL is very security-aware and will ask for your password regularly. You then reach the pgAdmin dashboard: on the left you can see the freshly installed PostgreSQL 13.2 server and, underneath, the databases — we will create our own next. The dashboard gives you a visual overview of server activity. We are now ready to dive in and create our very first database.

Summary

This lesson covers the step-by-step installation process of PostgreSQL on macOS. Users will learn how to download PostgreSQL from the official website, select the appropriate version, configure installation settings including password and port, and access the pgAdmin interface to manage the database server and view the dashboard.

Key points

  • Download PostgreSQL from the official website (postgresql.org) and select the macOS version from the packages and installers section
  • Choose the latest available PostgreSQL version during installation (example shown: version 13.2)
  • Configure installation settings including installation directory, database password, and server port selection
  • Set a secure password for PostgreSQL during the setup process for system access control
  • Use pgAdmin to access the SQL management interface by searching for it in applications and opening it
  • Verify successful installation by viewing the server dashboard in pgAdmin, which displays servers, databases, and server activity graphically

FAQ

How do I download PostgreSQL for Mac?

Visit the official PostgreSQL website by searching for PostgreSQL in your browser, click the download section, select packages and installers, choose your macOS operating system, and download the latest available version.

What is the password for PostgreSQL used during installation?

You set a password of your choice during the installation process. This password secures PostgreSQL and will be required when accessing the system through pgAdmin.

How do I access the PostgreSQL management interface after installation?

Search for pgAdmin in your applications folder, open it, and enter your PostgreSQL password when prompted. You will then access the dashboard where you can see servers, databases, and monitor server activity.