- Allow port 5432 in azure settings
- Make a rule to allow port 5432 in the VM's firewall
- Add to pg_hba.conf:
host all all 0.0.0.0/0 trust
- Make sure this line is in postgresql.conf:
listen_addresses = '*'
- Execute
SELECT pg_reload_conf(); to reload the .conf files.
- If needed, can reboot the server by stopping the service in Windows Services
- If encountering issues, make sure you are looking at the correct data folder! You can search for others using:
cd c:
dir /s /t pg_hba.conf