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

VM with PostgreSQL® 16 on Windows Server 2022 DC Azure Edition provides a robust, Azure-integrated database environment designed for stability and scalability. Built on Microsoft’s secure and long-term supported server platform, this solution combines the power of PostgreSQL 16 with rapid deployment, hardened configurations, and seamless cloud compatibility, making it ideal for enterprise teams running mission-critical PostgreSQL workloads in the cloud.

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 2022 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 2022 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