Skip to main content

Installing Postgresql on Windows

PostgreSQL is a powerful, open-source object-relational database system that is highly customizable and serves as a robust option for data storage and retrieval. This tutorial will walk you through the process of installing PostgreSQL on a Windows system.

Prerequisites​

Before starting the installation process, ensure that your system meets the following requirements:

  • A Windows system with administrator access.
  • Stable internet connection for downloading the setup file.

Step-by-Step Guide to Install PostgreSQL on Windows​

Step 1: Download PostgreSQL​

First, we need to download the setup file for PostgreSQL.

  1. Go to the official PostgreSQL download page.
  2. Choose Windows as the platform.
  3. Click on the Download the Installer link. This will take you to another page where you can select the version of PostgreSQL that you want to download. For most users, the latest version is the best choice.

Step 2: Launch the Installer​

Once the download is complete, locate the .exe file in your downloads folder and double click on it to launch the installer. If prompted by User Account Control, click Yes.

Step 3: Install PostgreSQL​

The PostgreSQL installer includes all of the software needed to run PostgreSQL, including a few additional utilities like pgAdmin, a popular graphical interface for PostgreSQL, and StackBuilder, a package manager that can be used to download and install additional PostgreSQL tools and drivers.

  1. Click Next on the first installation screen.
  2. The next screen will prompt you to select the installation directory. You can choose the default or specify a different directory, then click Next.
  3. Choose which components of the software to install. If you're unsure, it's safe to leave all boxes checked and click Next.
  4. The next screen allows you to choose the database directory, where all database data will be stored. Again, you can choose the default or specify a different directory. Click Next once done.
  5. The installer will then prompt you to set a password for the PostgreSQL superuser (postgres). Make a note of this password as you will need it to manage your databases.
  6. The next screen will prompt you to set the port number. The default port number is 5432. Unless there is a specific need to change it, leave it as the default and click Next.
  7. Choose the default locale used by new databases or you can choose a different one based on your location and click Next.
  8. The installer will then show a summary of your selections. Click Next to begin the installation.

The installation process may take a few minutes. Once it is completed, click Finish to close the installer.

Step 4: Verify Installation​

To verify that PostgreSQL was installed successfully:

  1. Open the pgAdmin utility, which was installed with PostgreSQL.
  2. In pgAdmin, click on Servers in the left-hand menu, then PostgreSQL 10 (or whatever version you installed).
  3. You'll be prompted to enter a password. This is the password you set during installation. Upon entering it, you should see that you are connected to the PostgreSQL server.

Congratulations! You have successfully installed PostgreSQL on your Windows system.

Wrapping Up​

This tutorial walked you through the process of downloading and installing PostgreSQL on a Windows system. Now, you're ready to begin exploring PostgreSQL and all of its powerful features.