PostgreSQL flexible server storage increase does not get reflected
After scaling up the storage of a PostgreSQL flexible server from 32GB to 64GB, the status shows "succeeded" and the information reflects 64GB. However, the free space percentage on the machine remains unchanged, and the sum of…
Azure Database for PostgreSQL
Unable to start the Azure Database for PostgreSQL flexible server
Hi Team, We are unable to start the Azure Database for PostgreSQL flexible server and getting error as: An error occurred starting the PostgreSQL server. We tried multiple times but still we are getting the same error. We tried creating automation task…
Azure Database for PostgreSQL
PostgreSQL Flexible Server upgrade from v12 → v14 fails with InternalServerError
Upgrade attempt of Azure Database for PostgreSQL Flexible Server in region North Europe from version 12 to 14 failed with InternalServerError. All prechecks passed: Auto-grow enabled Sufficient storage (512 GB) search_path includes PostGIS schemas …
Azure Database for PostgreSQL
Why arm template for postres flexible server fails with version 14 in west europe location?
Hi All, I am using ARM templates with Azure Pipelines to maintain the Infrastructure as Code approach in my project. I was using PostgreSQL v11, but because this is deprecated in Azure now, I upgraded it via the Azure Portal to version 14. Upgrade…
Azure Database for PostgreSQL
PostgreSQL flexible server stuck in dropping after quota increase
Received an error when originally deploying a postgreSQL flexible server in East US via Terraform: Status: "LocationIsOfferRestricted" │ Code: "" │ Message: "Subscriptions are restricted from provisioning in location 'eastus'.…
Azure Database for PostgreSQL
Passed Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL but the session crashed !
Hi, I just passed this applied skill assessment. I could see my score (18/24) in the background of my browser session as the dialog box was hung in the foreground. Now, when I log in to my Learn Profile it says I am eligible to retake the assessment in…
Azure Database for PostgreSQL
Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL
Hi, I just tried to take the 'Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL' assessment and failed. The first step in the assessment is to create an Azure PostgreSQL Flexible Server - I couldn't complete this task…
Azure Database for PostgreSQL
Azure Database for PostgreSQL Flexible Server stuck in "Stopped" state – critical client impact (East US, Burstable SKU)
Hello Microsoft team, This is an urgent situation affecting production. Issue Summary Our Azure Database for PostgreSQL Flexible Server in the East US region has been stuck in "Stopped" state for several days, and cannot be started, scaled, or…
Azure Database for PostgreSQL
Fix PostgreSQL Flexible Server AadAuthPrincipalCreationFailed after moving tenant
We had all our resources moved to a new Directory/tenant in Azure. However this did not migrate any tenantId properties in any resources, including our Azure PostgreSQL Flexible Server authConfig. This means I cannot change Microsoft Entra ID admin…
Azure Database for PostgreSQL
Azure Database for PostgreSQL Flexible Server won’t start after being stopped; returns InternalServerError
Hello Azure team, My Azure Database for PostgreSQL Flexible Server has been in a stopped state for approximately 4 weeks, and I’m unable to start it again. Whenever I try to start the server from either the Azure Portal or the CLI, I receive the…
Azure Database for PostgreSQL
Not able to upgrade Postgres Flexible Server from 12 to higher versions
I have been trying to upgrade postgres version from 12 to higher version for a long period of time, and whenever tried it always gives me this error:- The value of the 'Version' should be in: []. Verify that the specified parameter value is correct.…
Azure Database for PostgreSQL
[Azure PostgreSQL] TimescaleDB update timeline
I'm planning to migrate my DB to Azure but I'm facing an issue. Currently Azure's PSQL v17 only supports TimescaleDB v2.17.2. However, I'm relying new features introduced by TimescaleDB v2.21.x. This makes it impossible for me to move my data to Azure.…
Azure Database for PostgreSQL
Cannot create azure_ai extension in Postgres Flexible Server 16.9
When I run the following SQL command i get the below error, practically the same as here: https://free.blessedness.top/en-us/answers/questions/5537021/cannot-add-azure-ai-or-azure-storage-extension-to Can you please help? SQLCopy CREATE EXTENSION IF NOT…
Azure Database for PostgreSQL
PostgreSQL flexible server stuck in provisioning after InternalServerError
Received an error when originally deploying a postgreSQL flexible server in East US via Terraform: InternalServerError An unexpected error occured while processing the request Now it is stuck in "Provisioning" and if I click into the resource…
Azure Database for PostgreSQL
Can't setup Azure Database for PostgreSQL Flexible Server
Hi team, I trying to setup PostgreSQL Flexible Server. I've used both UI and CLI ways to setup it. During installation appears InternalServerError: (InternalServerError) An unexpected error occured while processing the request. Tracking ID:…
Azure Database for PostgreSQL
Recommendations on table partitioning
What are the recommended practices to move a table with a billion rows with multiple columns from a non-partitioned table to a partitioned table with minimal downtime in Azure PostgreSQL, few important related questions: How to decide the partition…
Azure Database for PostgreSQL
PGROUTING extension fails to deploy when added to postgres 16
PGROUTING extension was added recently to the extension list for postgres 16. However when I add that extension to my postgres v16 this is failing to deploy.
Azure Database for PostgreSQL
Estado droppoing PostgreSQL Flexible Server
Trate de hacer restore a mi DB y esta se quedo en estado Dropping por algún motivo Quiero que se elimine completamente
Azure Database for PostgreSQL
Data migration between two Azure Database for PostgreSQL Flexible Servers
I have two databases, one in each resource group. Both are of type Azure Database for PostgreSQL Flexible Server. For example let's say RG1, RG2 are the two resource groups. In RG1 I have Azure Database for PostgreSQL Flexible Server., let's say…
Azure Database for PostgreSQL
Azure PostgreSQL Flexible Server “Unavailable” after subscription reactivation
Hello community, I am experiencing a critical issue with an Azure Database for PostgreSQL – Flexible Server and need guidance: Situation: The subscription was previously suspended due to non-payment, and the payment has now been completed. The server…
Azure Database for PostgreSQL