I am working with an Azure Database for PostgreSQL Flexible Server that contains a table where new data is inserted daily. Over time, this has led to the accumulation of millions of rows, and the process of writing data to this table has significantly slowed down.

Starting sometime around the end of June, 2024/ beginning of July, 2024 the Azure Postgres Flexible Server firewall can no longer be opened via the REST API by creating an open firewall rule starting and ending with 0.0.0.0. The Networking page of the Portal has also changed for newly created Servers. The older version shows a radio button for Connectivity Method, while the new one just shows a checkbox under Public Access which must be checked before the Allow public access from any Azure service checkbox becomes visible.
Reviewing the REST API documentation still states that a firewall rule with 0.0.0.0 must be created: REST API docs.

Is there a new procedure, via the REST API, for allowing a Postgres Flexible Server to be accessed from other Azure services without having to manually check the Allow public access to this resource checkbox?

Old Networking Tab:

New Networking Tab, Unchecked:

Allow public access to this resource must be checked:

I have deployed my django app to azure ans use Azure Database for PostgreSQL flexible server. I have my postgresql database in local, how can i import data from my local server to Azure.

I manage a PostgreSQL database for my organisation which is set up on an Azure Database for PostgreSQL – Flexible Server.

I manage a PostgreSQL database for my organisation which is set up on an Azure Database for PostgreSQL – Flexible Server.