Installing PostgreSQL 11 on Windows. Step-by-step instruction

We will take a closer look at how to install PostgreSQL 11 on Windows, you will learn where to download PostgreSQL 11 for Windows, how the installation process looks like and how to connect to the PostgreSQL server.

PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS.

STEP-BY-STEP DESCRIPTION OF POSTGRESQL 11 INSTALLATION ON WINDOWS

STEP 1 — BOOTING THE GRAPHICAL POSTGRESQL 11 INSTALLER FOR 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 company, which prepares graphics distributions PostgreSQL for many platforms, including Windows.

Then 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.

As a result, you should download the file postgresql-11.0–1-windows-x64.exe with the size of approximately 187 megabytes.

STEP 2 — RUNNING THE POSTGRESQL INSTALLER 11

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

STEP 3 — SPECIFY THE DIRECTORY TO INSTALL POSTGRESQL 11

STEP 4 — CHOOSE COMPONENTS FOR INSTALLATION

STEP 5 — SPECIFY A DIRECTORY FOR DATABASE FILES

STEP 6 — SET A PASSWORD FOR THE POSTGRES SYSTEM USER

STEP 7 — SPECIFY THE PORT FOR YOUR POSTGRESQL INSTANCE

STEP 8 — SPECIFY THE ENCODING IN THE DATABASE

STEP 9 — CHECKING POSTGRESQL INSTALLATION PARAMETERS

STEP 10 — START THE INSTALLATION PROCESS

The installation has begun.

STEP 11 — FINISHING THE INSTALLATION

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

RUN PGADMIN 4 AND CONNECT TO POSTGRESQL SERVER 11

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, i.e. it is the password that you invented when installing PostgreSQL. Enter the password, tick “Save Password” to save the password, and each time you do not enter it, click “OK”.

As a result you will connect to a local PostgreSQL server.

WISSENSCHAFTSCOACHING: BERATUNG, COACHING, LEKTORAT, ÜBERSETZUNG