I'm using Azure App Service which created an Azure Database for PostgreSQL flexible server and I keep getting this error when trying to add my local IP to the firewall throught the Azure extension on VSCode:
This is a screenshot of the server name from the Azure portal:
I tried setting the Azure portal to public through "Network Connectivity" but the option is disabled for some reason:
What is my best course of action for being able to connect to my server through my client?
According to this, firewall rules specify allowed public IP address ranges. The firewall grants access to the server based on the originating IP address of each request. A firewall rule will be created when public access is enabled in the networking section of the database. With private access, no public endpoint is available, and only hosts located on the same network can access Azure Database for PostgreSQL - Flexible Server. Therefore, you should enable public access to the database while creating the server as shown below. However, according to this, it is not possible to change the networking option once the server is created.
Add the client IP address by creating a firewall rule as shown below:
You will then be able to connect to the database through the client successfully, as shown below: