Guidance on usage: VM with PostgreSQL® 17 on Minimal Windows Server 2025 DC

VM with PostgreSQL® 17 on Minimal Windows Server 2025 DC delivers a fast, resilient, and lightweight open-source database environment. It merges enterprise SQL capabilities with a minimal Windows Server core—ideal for lean, production-grade deployments.

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

Connection and Configuration to VM with PostgreSQL® 17 on Minimal Windows Server 2025 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. Log in to your Azure portal.
  2. Select your virtual machine from the list.
  3. In the Overview section, locate the Public IP Address.

1.2 Open Required Ports

Ensure the following TCP ports are open in network properties in the Azure firewall:

  • 3389 – for Remote Desktop access
  • 5432 – for PostgreSQL database access

To configure this:

  • Go to the VM’s Networking tab in Azure.
  • Add inbound port rules for TCP 3389 and TCP 5432.

2. Connect 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 the VM’s IP address and click Connect.
  1. When prompted, enter your username and password, then click OK.
  1. If you see a security warning, check the box and click Yes to proceed.

3. Access PostgreSQL 17 via pgAdmin

3.1 Open pgAdmin

Once logged into the VM, launch pgAdmin from the Start menu or desktop shortcut.

3.2 Set the Master Password

If prompted, set a master password for pgAdmin. This is required to manage your saved connections. Click OK to confirm.

3.3 Connect to PostgreSQL

  1. In the pgAdmin interface, click the server “PostgreSQL 17” in the left panel.
  1. When prompted for a password, enter the one provided in the PostgreSQL_Credentials file located on the desktop.
  1. Click OK to establish the connection.

You are now connected to your PostgreSQL 17 instance.

You’ve successfully connected to PostgreSQL® 17 on Windows Server 2025 Minimal DC virtual machine. You can now begin using the server for your database needs.

For additional details, refer to the official  PostgreSQL 17 Documentation