SQLServerCentral Article

Installing PostgreSQL 11 on Windows with Step-by-step Instructions

,

PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server.

Step-by-Step Installation on Windows

PostgreSQL is implemented for many operating systems: Windows, Linux, macOS. Now we will consider in detail all the steps you need to perform in order to install PostgreSQL on Windows operating system: starting from loading graphical installer, which, by the way, includes pgAdmin 4 – a graphical management tool PostgreSQL, with which you can write SQL queries, and ending with the Russification of pgAdmin 4.

Download the GUI Installer

You can of course download PostgreSQL 11 for Windows from the official PostgreSQL website. Here is the link: https://www.postgresql.org/download/windows/.

After going to the page, we can immediately click on the link, Download the installer. In this case we will be taken to the site of EnterpriseDB, which prepares graphics distributions PostgreSQL for many platforms, including Windows. On this page, we choose the platform and version of PostgreSQL. In our case, it is Windows and PostgreSQL 11. Click on the link “Windows x86-64” – this is the version for 64-bit versions of Windows.

This should start a download of the file, postgresql-11.0-1-windows-x64.exe, with the size of approximately 187MB.

Running the Installer

Run the downloaded file. At first the installer will check if all the necessary components are present, in particular the Visual C++ redistributable. If necessary, i.e. if they are absent, it will install them itself.

After that a welcome window will be opened, click “Next”.

Running the PostgreSQL installer 11

Then we need to specify the path to the directory where we want to install PostgreSQL 11, but we can leave it as default. If necessary, specify the path and click “Next”.

Specify the directory to install PostgreSQL 11

On this step we can mark the components that we need to install. As you can see, among the components there is pgAdmin 4. Leave the checkboxes against the components that we need and click “Next”.

Choose components for installation

Next, we need to specify the directory where the database files will be located by default. In this case it is better to specify a separate drive. Click “Next”.

Specify a directory for database files

Now we need to set a password for the postgres user. In other words, for the PostgreSQL Server administrator. We enter the password and confirm it. Click “Next”. Be sure to use a strong password here.

Set a password for the postgres system user

Next, if necessary, we can change the port on which PostgreSQL Server will respond, but we can leave it by default. Click “Next”.

Specify the port for your PostgreSQL instance

The next step, if there is a need to specify a specific data encoding in the database, we can select the desired Locale from the drop-down list. I leave it as default, click “Next”.

Specify the encoding in the database

Next we check the parameters we entered earlier for PostgreSQL installation. If everything is correct, click “Next”.

Checking PostgreSQL installation parameters

To start the PostgreSQL installation process in this window, click “Next”.

Start the installation process

The installation will run as it does for most software programs.

The installation has begun.

Finishing the Installation

The PostgreSQL 11 installation process takes only 2-3 minutes. When you see the message “Completing the PostgreSQL Setup Wizard” the PostgreSQL installation, pgAdmin 4 and other components will have been installed.

In the last window we will be offered to run Stack Builder to load and install additional components. If you do not need anything, uncheck “Lanch Stack Builder at exit?” and press “Finish”.

Finishing the installation

Connect to the PostgreSQL 11 Server

If you installed pgAdmin together with PostgreSQL, you can use this to connect to the server. To start pgAdmin 4 press “Start Menu – > PostgreSQL 11 -> pgAdmin 4”. The new version of pgAdmin 4 has a web interface, so you will launch a browser that will open the pgAdmin 4 application.

To connect to your newly installed local PostgreSQL 11 server in your server browser, click on “PostgreSQL 11”. This will launch the “Connect to Server” window, where you need to enter the password of the system user postgres, the password that you entered when installing PostgreSQL. Enter the password, tick “Save Password” to save the password, and each time you do not enter it, click “OK”.

Run pgAdmin 4 and connect to PostgreSQL server 11

If everything is correct, you will connect to a local PostgreSQL server.

As a result you will connect to a local PostgreSQL server

Summary

This  article walks through the installation of PostgreSQL on your local system. From here, you can now use this to build a database that can be used in your application.

Resources

Rate

2.67 (3)

You rated this post out of 5. Change rating

Share

Share

Rate

2.67 (3)

You rated this post out of 5. Change rating