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

Deploy PostgreSQL® 17 in a stripped-down Windows Server 2019 Datacenter environment delivers a secure platform ideal for lean, scriptable deployments where resource efficiency, control, and compliance are key. Built for IT administrators, developers, and teams in regulated industries.

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