1,658 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

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
asked 2025-09-16T18:50:48.9066667+00:00
John 0 Reputation points
commented 2025-10-28T07:56:54.75+00:00
John 0 Reputation points
0 answers

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
asked 2025-10-24T02:55:54.7166667+00:00
CardyaiDevops 0 Reputation points
commented 2025-10-28T06:53:13.6533333+00:00
VRISHABHANATH PATIL 1,295 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-10-26T08:14:35.7966667+00:00
Blueoshan Support 0 Reputation points
commented 2025-10-28T06:33:18.03+00:00
VRISHABHANATH PATIL 1,295 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-10-24T09:30:17.55+00:00
Bołoz Dawid 0 Reputation points
commented 2025-10-28T04:41:09.9033333+00:00
Mahesh Kurva 9,575 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-10-27T19:47:52.2166667+00:00
Jarvis 20 Reputation points
edited a comment 2025-10-27T23:24:00+00:00
Swapnesh Panchal 740 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-10-27T18:11:54.2066667+00:00
Paul Lynch 16 Reputation points
answered 2025-10-27T20:03:56.3833333+00:00
Paul Lynch 16 Reputation points
0 answers

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
asked 2025-09-30T10:39:11.7933333+00:00
Paul Lynch 16 Reputation points
commented 2025-10-27T20:00:49.9033333+00:00
Paul Lynch 16 Reputation points
0 answers

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
asked 2025-10-17T16:22:52.4333333+00:00
Admind 0 Reputation points
edited a comment 2025-10-27T18:23:53.8833333+00:00
LTello 20 Reputation points
0 answers

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
asked 2025-10-27T11:13:10.1466667+00:00
Jakob Pedersen 0 Reputation points
commented 2025-10-27T16:50:24.4266667+00:00
Manoj Kumar Boyini 405 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-10-22T01:15:42.17+00:00
Yantra 0 Reputation points
commented 2025-10-27T15:26:31.15+00:00
Anthony Perez 0 Reputation points
0 answers

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
asked 2025-10-24T12:00:15.6433333+00:00
Rohit Gandhi M 0 Reputation points
commented 2025-10-27T13:39:31.7+00:00
Kalyani Kondavaradala 3,150 Reputation points Microsoft External Staff Moderator
1 answer

[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
asked 2025-10-24T08:51:52.8566667+00:00
Andre Mazayev 0 Reputation points
answered 2025-10-27T11:56:09.98+00:00
Mahesh Kurva 9,575 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-09-09T08:17:24.8933333+00:00
Nimrod Senhav 0 Reputation points
commented 2025-10-27T06:26:26.31+00:00
VRISHABHANATH PATIL 1,295 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-09-30T18:34:34.4666667+00:00
Tim Reed 20 Reputation points
commented 2025-10-24T08:16:51.3633333+00:00
Pavlo Chavyr 0 Reputation points
1 answer

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
asked 2025-10-21T18:07:52.7966667+00:00
Dmitry Maksymets 0 Reputation points
edited a comment 2025-10-24T20:01:46.9966667+00:00
Swapnesh Panchal 740 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-10-22T15:33:43.6266667+00:00
Gaurav Pant 0 Reputation points
edited a comment 2025-10-27T06:12:12.2033333+00:00
Mahesh Kurva 9,575 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-10-23T13:45:37.9966667+00:00
Christian Shardey 0 Reputation points
edited a comment 2025-10-24T09:09:02.5533333+00:00
Christian Shardey 0 Reputation points
0 answers

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
asked 2025-10-23T18:45:35.5+00:00
Brayan Riveros 0 Reputation points
edited a comment 2025-10-24T13:09:53.7533333+00:00
Swapnesh Panchal 740 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-10-24T05:05:10.11+00:00
Sunayana Rambhatla 0 Reputation points
answered 2025-10-24T12:17:21.1+00:00
Manoj Kumar Boyini 405 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-10-25T22:46:33.16+00:00
Diego Armas 0 Reputation points
answered 2025-10-27T02:24:05.4833333+00:00
Jerald Felix 7,910 Reputation points