How to install PostgreSQL on Windows

To install a DBMS, you need to have the rights and competencies of a system administrator in the company’s network.

In this article we will install step by step PostgreSQL on Windows with default settings. For detail information about PostgreSQL administration official documentation of the PostgreSQL Open-Source project or documentation of different PostgreSQL derivatives can be used.

Step 1: Obtain the Installation Archive #

Step 2: Prepare the Installation Directory #

  • Create a new directory where you want to store the installation files.
  • Extract the contents of the installation archive into this directory.

Step 3: Run the Installer #

Locate the postgresql-version-(x64).msi file in the extracted directory. Double-click the file to start the installation process.

Step 4: Begin Installation #

  • Click Start to initiate the installation.
  • If Windows operation system ask you to confirm the installation then press Yes.
  • Exit all Windows programs.

Step 5: Select installation options #

  • Choose appropriate install location.
  • The “Install as a service” checkbox should be set up to install the PostgreSQL as a service.
  • Click Next.

Step 6: Start ‘Secondary Logon’ service if necessary #

  • If the ‘Secondary Logon’ service is not running then Sevice check error will pop-up.
  • Open the Run window by pressing Win + R and type services.msc.
  • Enable and start ‘Secondary Logon’ service.

Step 7: Initialize database cluster #

  • Set a password that is at least 8 characters long, includes at least one number, and contains at least one special character.
  • Click Next.

Step 8: Install PostgreSQL #

Click Next to installPostgreSQL:

Step 9: Complete the Installation #

Once the installation is finished, click Finish.

Step 10: Verify the Installation #

  • Open the Run window by pressing Win + R and type services.msc.
  • In the Services console, ensure that the 1C:Enterprise service is enabled and its status is set to Running.

Conclusion #

We have installed step by step PostgreSQL on Windows. Further you need to install 1C:Enterprise Server.

Scroll to Top