Delete firewall rules

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, under the Settings section, select Networking.

   

3. To delete a firewall rule, select the trash bin icon located to the right of the rule definition.

   

4. To delete the firewall rule that allows connections from any IP address allocated to any Azure service or asset, clear the Allow public access from any Azure service within Azure to this server checkbox.

   

   Important

   Allow public access from any Azure service within Azure to this server creates a firewall rule whose start and end IP addresses are set to 0.0.0.0. The presence of this rule configures the firewall to allow connections from IP addresses allocated to any Azure service or asset, including connections from the subscriptions of other customers.

5. Select Save.

   

6. A notification informs you that the changes are being applied.

   

7. When the process completes, a notification informs you that the changes were applied.

   

You can delete firewall rules from a server via the az postgres flexible-server firewall-rule delete command.

az postgres flexible-server firewall-rule delete \
  --resource-group <resource_group> \
  --server-name <server> \
  --name <rule>

If you attempt to delete a firewall rule on a server which isn't in Ready state, you receive an error like this:

Code: InternalServerError
Message: An unexpected error occured while processing the request. Tracking ID: '<tracking_id>'

If you attempt to delete a firewall rule with an invalid name, you receive an error like this:

The firewall rule name can only contain 0-9, a-z, A-Z, '-' and '_'. Additionally, the name of the firewall rule must be at least 3 characters and no more than 128 characters in length. 

If you attempt to remove a firewall rule from a server that doesn't have public access enabled, you receive an error like this:

Firewall rule operations cannot be requested for a private access enabled server.