This tutorial takes PostgreSQL database as an example. You can also install other databases by following the documentation from the vendor.

In this tutorial, we will set up a database server with the PBDemo PostgreSQL database running in an independent machine.

Step 1: Set up the database server with the following OS and software:

  • Windows Server 2019 (64-bit)

  • PostgreSQL 12

    Click here to download the installer for PostgreSQL.

Step 2: Configure Windows Defender Firewall on the database server to allow the database server port (5432 in this tutorial or any port number you choose). The section "Configuring Windows Defender Firewall" has detailed instructions.