@Tom Rye welcome to the Microsoft Q&A community.
Here are a few things you might want to check:
Azure Service Health – Check if there are any ongoing outages or maintenance affecting Azure Database for PostgreSQL.
Firewall & Networking – Ensure that your database server is still allowing connections from your App Service. Sometimes, firewall rules or VNET configurations change unexpectedly.
Server Status – If restarting the server fails, it could indicate an underlying issue with Azure's infrastructure. You might need to raise a support ticket with Microsoft.
Connection Security Settings – Verify that your database settings haven't changed, such as "Allow access to Azure services" being disabled.
Logs & Metrics – Check Azure Monitor logs for any unusual activity or errors related to your database.
You can find a discussion on a similar issue here, which might provide additional insights. If the problem persists, I recommend reaching out to Azure Support directly with your tracking ID for further investigation.
I hope these helps. Let me know if you have any further questions or need additional assistance.
Also if these answers your query, do click the "Upvote" and click "Accept the answer" of which might be beneficial to other community members reading this thread.