Monday, October 3, 2022

How To Set up PostgreSQL on Windows Server 2019

In this article, we want to teach you How To Set up PostgreSQL on Windows Server 2019.

PostgreSQL (often referred to as Postgres) is an open-source object-relational database management system with a particular focus on extensibility and standards compliance.

Set up PostgreSQL on Windows Server 2019

To install PostgreSQL on your Windows Server, you can follow the steps below.

Install PostgreSQL on Windows Server 2019

In this guide, we will install PostgreSQL from the PostgreSQL enterprise website.

First, visit the page and get the latest version of PostgreSQL.

PostgreSQL installer for windows server

Then, open your PostgreSQL downloaded file on Windows Server 2019.

You will see the PostgreSQL setup wizard, click next to continue.

PostgreSQL setup wizard on windows server

In the next window, you need to choose your installation directory for your PostgreSQL on Windows Server and click on the next.

PostgreSQL installation directory

At this point, you need to select the PostgreSQL components on Windows server 2019 that you want to install. By default, all components are selected. If you don’t want components clear them and click on the next.

set up postgreSQL components

Now you need to choose your Data directory for your PostgreSQL and click on the next.

PostgreSQL data directory

Next, you need to set up a password for the PostgreSQL superuser and click on the next button to continue.

set up password for PostgreSQL superuser

By default, PostgreSQL listens on port 5432. Select the port number that you can access on the PostgreSQL web and click the next button.

PostgreSQL port number

Here you need to select the time zone and the default language. Then, press the next button to continue your setup.

PostgreSQL advanced options on Windows server

Finally, you can confirm your pre-installation summary and click on the Next button.

PostgreSQL pre-installation summary

Your setup is now ready to start the PostgreSQL installation on Windows Server 2019 by clicking on the Next button.

PostgreSQL is ready to install on Windows Server

When your installation is completed, click on the finish button.

Additional utilities and add-ons can be installed using the Stack builder.

PostgreSQL complete setup

In the stack builder wizard, select your server and click next.

PostgreSQL stack builder on Windows server

In the next window, select the additional applications for PostgreSQL that you want to install and press next.

PostgreSQL additional apps

Now select your download directory and click next.

download additional packages for PostgreSQL

Then, you just need to press next to install your additional apps.

PostgreSQL install additional apps

When your installation is completed, your windows server 2019 will restart.

Access the PostgreSQL Instance

At this point, you need to open your pgAdmin4. and it will ask you the password that you have set for the PostgreSQL super enter it and you will see all the objects in your server.

pgAdmin4 on windows server 2019

Conclusion

At this point, you learn to set up and configure PostgreSQL on Windows Server 2019.

Hope you enjoy using it.

Related Articles

2 COMMENTS

    • If you have installed PostgreSQL, the username and password have been set for you before and you can use them. And be sure to download the PostgreSQL from the correct source.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Articles