Guidance on usage: VM with PostgreSQL® 16 on Windows Server 2025 DC Azure Edition

VM with PostgreSQL® 16 on Windows Server 2025 DC Azure Edition is a ready-to-deploy solution delivering high performance, robust security, and enterprise-grade scalability in the cloud. The image is optimized for rapid Azure deployment, enhanced SQL execution, and seamless integration with modern IT infrastructures and critical business applications.

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 2025 DC Azure Edition

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 2025 DC Azure Edition 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