Enable public access

If you enable public access, connectivity to the server is also possible via private endpoints.

With public access enabled, you can also configure firewall rules to allow connections originating from specific IP addresses, or from any Azure service.

When you enable public access, any firewall rules that already existed last time the server was configured with enabled public access are enforced again.

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Overview.

   

3. The status of the server must be Available, for the Networking menu option to be enabled.

   

4. If the status of the server isn't Available, the Networking option is disabled.

   

Note

Any attempt to configure the networking settings of a server whose status is other than available, would fail with an error.

5. In the resource menu, select Networking.

   

6. Select the Allow public access to this resource through the internet using a public IP address checkbox.

   

7. Select Save.

   

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

   

9. Also, the status of the server changes to Updating.

   

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

    

11. Also, the status of the server changes to Available.

    

CLI

You can enable public access on a server via the az postgres flexible-server update command.

az postgres flexible-server update --resource-group <resource_group> --name <server> --public-access enabled

If you attempt to enable public access on a server which isn't in Available state, you receive an error like this:

Code: 
Message: Server <server> is busy with other operations. Please try later

If you attempt to enable public access on a server which wasn't deployed with networking mode public access (allowed IP addresses), you don't receive an error. The request to change that configuration is ignored.

To determine if a server has public access enabled or disabled, run the following command:

az postgres flexible-server show --resource-group <resource_group> --name <server> --query '{"publicAccess":network.publicNetworkAccess}'

Related content

• Networking.
• Disable public access.
• Add firewall rules.
• Delete firewall rules.
• Add private endpoint connections.
• Delete private endpoint connections.
• Approve private endpoint connections.
• Reject private endpoint connections.