Opening PostgreSQL port in the windows Firewall

For a PostgreSQL windows server to be visible by client machines on the network, it is necessary to enable the access to the port in the firewall.

Click on Control Panel → All Control Panel Items → Windows® Firewall → Allowed Programs

      1. Click on Allow another program button.

      2. Select the Postgres program from the list and click on Add button.

      3. Select the Postgres program in the list and click on the Details button.

      4. Provide the postgres service port, by default 5432.

      5. Select TCP and click on the OK button.