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

VM with PostgreSQL® 17on Windows Server 2025 DC provides a scalable and production-grade database environment combining the flexibility of PostgreSQL with the proven stability of Microsoft’s latest server OS. Ideal for mission-critical applications, this preconfigured VM supports modern workloads with enhanced performance, advanced SQL features, and enterprise-level security.

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

Connection and Configuration to VM with PostgreSQL® 17on 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 DC virtual machine. You can now begin using the server for your database needs.

For additional details, refer to the official  PostgreSQL 17 Documentation