Putting PostgreSQL into operation on Windows Server

A system that does not cost anything to use is known as PostgreSQL. Every single user has unrestricted to the system’s original source at no additional cost.

This post will cover the installation of PostgreSQL as well as the installation of extra components using Stack .

As an illustration, Server 2018 will be utilized.


Download the distribution kit from the official site. The resource provides releases that vary in accordance with the bit depth and operating system family. Choose the Windows x64 version 12.0 operating system:

Distribution download

Screenshot #1. Download distribution.

Run the installer and follow its prompts. At one stage, you will need to create a password:

Setting a password

Screenshot #2. Set a password.

We enter following the following rules: at least 7 characters, uppercase and lowercase letters of the Latin alphabet, and numbers.

The next step is to specify the port and localization. We leave the port number unchanged, and select the localization “Russian”:

Choosing a localization

Screenshot #3. Choose a localization.

The installation process will take no more than 5 minutes.

Configuring PostgreSQL

When finished, the following message will appear on the screen:

Server selection

Screenshot #4. Server selection.

The system will ask you to specify the address of the server from which the Stack Builder utility will download additional libraries and tools for the DBMS. Select as shown in the screenshot and click “Next”. The installer will show a list of available download options. You need to install the component. It is integrated into the PEM-HTTPD package:

Installing the Apache component

Screenshot #5. Installing the Apache component.

Next, select the installation directory – it is recommended to leave the default path, and wait for the installation to complete.

The next step is to connect to the DBMS. Open the Windows command line, go to the section with PostgreSQL installed:

cd "C:Program FilesPostgreSQL9.6bin"

Connecting to console mode:

.psql.exe -U postgres

Now the user can manage the DBMS through the terminal.


Welcome to the world of DomainRooster, where roosters (and hens) rule the roost! We're a one-stop shop for all your entrepreneurial needs, bringing together domain names and website hosting, and all the tools you need to bring your ideas to life. With our help, you'll soar to new heights and hatch great success. Think of as your trusty sidekick, always there to lend a wing and help you navigate the sometimes-complex world of domain names and hosting. Our team of roosters are experts in their fields and are always on hand to answer any questions and provide guidance. So why wait? Sign up today and join the ranks of the world's greatest entrepreneurs. With DomainRooster, the sky's the limit! And remember, as the saying goes, "Successful people do what unsuccessful people are not willing to do." So don't be afraid to take that leap of faith - DomainRooster is here to help you reach for the stars. Caw on!