SQL ET POSTGRE 2.4 : Installation PostgreSQL for Windows

In this video we install PostgreSQL on Windows. If you are on macOS, another video covers that case. Open your favourite search engine and look for "PostgreSQL". Go to the official PostgreSQL website, click on the second link if needed, then click Download. Pick the latest Windows version and start the download. You then end up with the installer ready to launch.

Running the Windows installer

Double-click the downloaded installer and click Next. Keep the suggested installation directory and continue. We are going to do a default installation, so click Next again. When prompted, choose a password — this is the password you will use to access PostgreSQL, and pgAdmin will ask for it regularly. Leave the suggested port as is, and keep the default configuration on the next screen. Start the installation. It takes a few minutes.
  • Download from the official PostgreSQL website.
  • Choose a strong password (you will reuse it often).
  • Keep the default port unless you have a reason to change it.
  • Untick Stack Builder at the end of the wizard.
When the installation completes, untick the Stack Builder assistant and finish the installer. Now launch pgAdmin — the graphical client for PostgreSQL. Type in the password you set earlier, and you are ready to start working with PostgreSQL on Windows. In the next videos we will create our first database and tables.

Summary

This lesson provides a complete walkthrough of installing PostgreSQL 12 on Windows. It covers downloading from the official PostgreSQL website, running the installer with default settings, setting a password for database access, configuring the port, and completing the installation. The guide concludes with launching pgAdmin to begin working with PostgreSQL.

Key points

  • Download PostgreSQL from the official website and select the Windows-compatible version
  • Create and remember a strong password during installation—this credential is required for all PostgreSQL access
  • Leave port and configuration settings at their default values unless specific changes are needed
  • Uncheck Stack Builder at the end of installation if additional tools are not required
  • Launch pgAdmin immediately after installation to verify the setup and manage your PostgreSQL databases
  • The entire installation process is relatively quick and mostly automated with recommended default options

FAQ

What is the password I set during PostgreSQL installation used for?

The password you enter during installation is the master password for PostgreSQL database access. It will be required regularly whenever you access and manage your PostgreSQL databases and is essential for security.

Should I change the default port configuration during PostgreSQL installation?

The default port setting is appropriate for most standard installations and does not need to be modified unless you have specific requirements or port conflicts with other applications.

What is Stack Builder and do I need to install it?

Stack Builder is an optional component that installs additional tools alongside PostgreSQL. It can be unchecked and skipped if not needed; the core PostgreSQL installation will work perfectly without it.