I recently moved to a new location (with new IP address), and I am using the same machine with unchanged configuration. I have attempted to connect with the same computer from my office, and it connects just fine.
When attempting to connect to our postgres database via pgadmin I am getting the following error:
FATAL: no pg_hba.conf entry for host "<ipv4-address>", user "<user>", database "postgres", SSL on
I have added the new IP address to Connection Security in the Azure portal, but I am still unable to connect. I thought it might be a temporary hiccup, so I have tried to add and remove the IP-address several times and waiting a day before attempting to connect, but the result is the same.
Any advice on how to proceed? Currently working from home due to the COVID-19 situation and the Postgres database is crucial to my workflow.
I recently moved to a new location (with new IP address), and I am using the same machine with unchanged configuration. I have attempted to connect with the same computer from my office, and it connects just fine.
When attempting to connect to our postgres database via pgadmin I am getting the following error:
FATAL: no pg_hba.conf entry for host "<ipv4-address>", user "<user>", database "postgres", SSL onI have added the new IP address to Connection Security in the Azure portal, but I am still unable to connect. I thought it might be a temporary hiccup, so I have tried to add and remove the IP-address several times and waiting a day before attempting to connect, but the result is the same.
Any advice on how to proceed? Currently working from home due to the COVID-19 situation and the Postgres database is crucial to my workflow.