Guide – How To Start – Database with PostgreSQL® 17 based on Minimal Windows Server 2016 DC

Deploy PostgreSQL® 17 on a streamlined Windows Server 2016 Datacenter environment — an ideal fit for secure on-premises or hybrid scenarios where stability and control are critical.

This is a quick deployment and ready-to-run image.

Simple and rapid installation. Easy to maintain.

Connection and configuration to Database with PostgreSQL® 17 based on Minimal Windows Server 2016 DC

1. For the connection to the server, you should know the IP address of the VM. You can find it in Azure’s account. You need to select the virtual machine from the list. By clicking the item “Overview”, your IP is displayed in the line “Public IP Address”.

2. To work, TCP port 5432 must be open. To check this, you can in the Network settings of your VM.

3. To connect to the virtual machine, run the “Remote Desktop Connection” shortcut (Win + R). In the window that appears, enter “mstsc” and click “OK”.

4. In the window that appears, enter the virtual machine’s IP and click “Connect”.

5. Enter your username and password in the window that appears and click “OK”.
   
6. Check the box and click “Yes”.

7. Run pgAdmin. 

8. By default, you can be asked to set a master password (If not, you should proceed to the next step)

Set the password and click “OK”.

9. Click the server “PostgreSQL 17”

10. Enter the password from the file PostgreSQL_Credentials on the desktop

11. Your connection is ready

More information – 17: PostgreSQL 17.2 Documentation