Guidance on usage: VM with PostgreSQL® 16 on Windows Server 2019 DC

VM with PostgreSQL® 16 on Windows Server 2019 DC delivers a reliable and optimized SQL database environment preconfigured for enterprise deployments. Running on Microsoft’s proven Windows Server 2019 platform, this VM ensures compatibility with legacy systems, robust security policies, and consistent long-term support.

Effortless installation. Ready-to-run with easy maintenance. Explore now for a smooth experience!

Connection and Configuration to VM with PostgreSQL® 16 on Windows Server 2019 DC

1. Prerequisites

1.1 Locate the VM’s IP Address

To connect to the server, you need the public IP address of your virtual machine:

  1. Sign in to your Azure portal.
  2. Select your VM from the list.
  3. In the Overview tab, find the Public IP Address field.

1.2 Open Required Ports

Ensure the following TCP ports are open in your Azure network settings:

  • 3389 – for Remote Desktop Protocol (RDP)
  • 5432 – for PostgreSQL connections

To do this:

  • Navigate to your VM’s Networking tab.
  • Add inbound rules for the required ports.

2. Connecting to the Virtual Machine

2.1 Launch Remote Desktop

  1. Press Win + R, type mstsc, and click OK.
  1. In the Remote Desktop Connection window, enter your VM’s IP address and click Connect.
  1. Enter your username and password when prompted and click OK.
  1. If prompted with a certificate warning, check the box and click Yes to continue.

3. Access PostgreSQL 16 via pgAdmin

3.1 Open pgAdmin

Once logged in to the virtual machine, launch pgAdmin from the Start menu or desktop.

3.2 Set Master Password

If prompted, set a master password to secure your saved connections. Click OK to proceed.

3.3 Connect to the PostgreSQL Server

  1. In the pgAdmin dashboard, click on the server named “PostgreSQL 16”.
  1. Enter the password provided in the PostgreSQL_Credentials file located on the desktop.
  1. Click OK to complete the connection.

You’re all set to begin using PostgreSQL® 16 on Windows Server 2019 DC VM. Whether you’re managing databases, running queries, or exploring PostgreSQL features, this environment provides the flexibility and performance you need.

More information – PostgreSQL 16 Documentation