1,728 questions with Azure Database for PostgreSQL tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

Replication lag in PostgreSQL Replay Lag is extremely high (236:41:55.093431

Replica showing Active.One more repliucation slot showing delay PostgreSQL Replay Lag is extremely high (236:41:55.093431

Azure Database for PostgreSQL
asked 2025-11-04T14:34:03.2933333+00:00
accepted 2025-11-21T14:14:47.4266667+00:00
1 answer

I can't scale compute on my postgres flexible server hosted in East US

I don't have any choice to upgrade my compute on postgres flexible server. The server is in East US ... As you can see above, there are no other choices... I need to switch to an 8 vCores SKU ... Why is it not available? I know you are resource…

Azure Database for PostgreSQL
asked 2025-11-20T20:01:19.85+00:00
Lachapelle, Serge 0 Reputation points
answered 2025-11-21T00:50:40.37+00:00
Swapnesh Panchal 1,540 Reputation points Microsoft External Staff Moderator
1 answer

updating state is taking too long

The server is currently in 'updating' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long. I need someone to work with us asap

Azure Database for PostgreSQL
asked 2025-11-20T15:46:59.83+00:00
JaimeMallari-5866 0 Reputation points
answered 2025-11-20T17:35:13.5333333+00:00
Manoj Kumar Boyini 1,735 Reputation points Microsoft External Staff Moderator
2 answers

How can i change extension schema

How can i change extension(postgis) schema from public to my custom schema in Azure Database FOR PostgreSQL flexible servers?

Azure Database for PostgreSQL
asked 2025-11-19T14:27:16.7833333+00:00
Andrey Makarenko 25 Reputation points
answered 2025-11-20T05:40:09.7633333+00:00
Pilladi Padma Sai Manisha 590 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

When Azure Database for PostgreSQL flexible servers impacting event in East US will be resolved

Hi community, Does anyone know the ETA of the current issue for Azure Database for PostgreSQL flexible servers impacting event in East US will be recovered? https://app.azure.com/h/RLDP-VW8/c26251 It has been more than a month, our PROD is running in…

Azure Database for PostgreSQL
asked 2025-11-19T05:23:05.0766667+00:00
Daniel Young 20 Reputation points
accepted 2025-11-19T22:16:34.9633333+00:00
Daniel Young 20 Reputation points
4 answers

Upgrading Azure Database for PostgreSQL flexible server from 15.14 to 16 or 17 versions failed

During process upgrade Azure Database for PostgreSQL flexible server from 15.14 to 16 or 17 versions I see this error: { "code": "ParameterOutOfRange", "message": "The value of the 'Version' should be in: []. Verify…

Azure Database for PostgreSQL
asked 2025-11-19T15:59:55.1033333+00:00
Dmitrii Nikonorov (LDL) 5 Reputation points
answered 2025-11-19T17:52:42.5266667+00:00
Swapnesh Panchal 1,540 Reputation points Microsoft External Staff Moderator
1 answer

How to buy Reservation for Postgresql flexible servers HA instance

I can't seem to find any official documentation on precisely how to buy Azure PostgreSQL's flexible server instance's High Availability instance (Secondary instance). I am aware buying the Reservation will apply for the primary instance. Does anyone have…

Azure Database for PostgreSQL
asked 2024-08-02T02:03:17.58+00:00
Anonymous
commented 2025-11-19T15:02:48.8033333+00:00
nico 30 Reputation points
2 answers

PostgreSQL flexible server upgrades fail with InternalServerError

Hi, all my PG flexible server upgrades from 16.9 to 17.6 fail with the following status: "statusMessage":…

Azure Database for PostgreSQL
asked 2025-10-28T09:32:24.8033333+00:00
Daniel Gellert 5 Reputation points
answered 2025-11-19T07:02:22.7966667+00:00
Daniel Gellert 5 Reputation points
1 answer

pg_trgm Extension Not Allowed on Azure Database for PostgreSQL Flexible Server – Alternatives and Cloud Comparison

Dear Microsoft Community, We are currently exploring advanced search functionality for our application hosted on Azure Database for PostgreSQL (Flexible Server). Our use case involves fuzzy text search on a product catalog, specifically using a string…

Azure Database for PostgreSQL
asked 2025-08-28T10:05:16.4733333+00:00
Rishav Arora 25 Reputation points
answered 2025-11-19T06:54:54.4266667+00:00
Sina Salam 26,666 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Cannot create new Azure Postgres Flexible Server in eastus despite quota increase

When creating another Azure Postgres Flexible Server through terraform we get the error below. We do have existing Azure Postgres Flexible Server in that region. After requesting a quota increase the error persists. Error: creating Flexible Server…

Azure Database for PostgreSQL
asked 2025-11-14T08:48:27.8333333+00:00
Daan de Bruin 20 Reputation points
accepted 2025-11-18T18:05:15.69+00:00
Daan de Bruin 20 Reputation points
2 answers

How to add pgaadauth in azure pg flexible servers

Hello, I am trying to add pgaadauth as a server parameter under the azure.extensions and it is not listed as an option to add. But when run the below query: SELECT * FROM pg_available_extensions; pgaadauth is listed as version 1.7 and installed is…

Azure Database for PostgreSQL
asked 2025-11-18T01:56:18.37+00:00
Application Admin 0 Reputation points
answered 2025-11-18T04:06:55.9866667+00:00
VRISHABHANATH PATIL 2,305 Reputation points Microsoft External Staff Moderator
2 answers

Remove stale principal from Azure PostgreSQL flexible server database

Our Azure PostgreSQL Flexible Server has a stale AAD principal mapping created with pgaadauth_create_principal(). The corresponding Managed Identity was deleted and recreated, so its Object ID changed. We cannot drop or update the principal because…

Azure Database for PostgreSQL
asked 2025-11-12T15:24:10.72+00:00
Arndt, Lothar (001) (EXT) 0 Reputation points
answered 2025-11-17T12:05:12.9466667+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Zone Redundant HA cannot be enabled on Azure flexible Postgres Server

I cannot enable Zone Redundant HA on my Azure flexible Postgres Server even though it is in East US and I have sufficient quota left for the compute VM. The message says the region does not support it, but your documentation says it does and I don't see…

Azure Database for PostgreSQL
asked 2025-11-08T22:35:03.7566667+00:00
Jonathan Meuth 20 Reputation points
answered 2025-11-17T12:03:08.5633333+00:00
VRISHABHANATH PATIL 2,305 Reputation points Microsoft External Staff Moderator
1 answer

Resource was created with failed state and cannot be deleted

I created Azure Database for PostgreSQL flexible server but it ended up in a failed state. I want to delete this resource but it doesn't allow me. I get the following error: The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers'…

Azure Database for PostgreSQL
asked 2025-10-08T16:46:58.6133333+00:00
Martin Masek 0 Reputation points
edited the question 2025-11-14T12:30:12.57+00:00
GitaraniSharma-MSFT 50,181 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

Error restoring backup An unexpected error occured while processing the request. Tracking ID: '3f9abf0b-3c73-47ba-b858-a61ca72fb77f' (código: InternalServerError)

When trying to restore a backup using the Azure portal, I have tried several ways with different availability zones, following the help suggestions and in all cases, I get this error. Please your help …

Azure Database for PostgreSQL
asked 2025-10-17T13:14:53.1566667+00:00
Andy 20 Reputation points
accepted 2025-11-13T18:14:38.3666667+00:00
Andy 20 Reputation points
2 answers

Unable to add tags to an Azure Database for PostgreSQL flexible server

We are trying to add tags to an existing Azure Database for PostgreSQL flexible server. We have tried via the Azure Portal and the CLI, but it will not work. The command I run is: az postgres flexible-server update -n <servername> -g…

Azure Database for PostgreSQL
asked 2025-03-25T16:49:54.0433333+00:00
Mark Schlesinger 0 Reputation points
answered 2025-11-13T14:23:23.69+00:00
Stanley Aghara Odera 0 Reputation points
2 answers

Enable TimescaleDB for PostgreSQl Flexi server

Hello Azure Support Team, Could you please confirm if Azure Database for PostgreSQL Flexible Server currently supports installing and running TimescaleDB Community Edition (preferably the latest stable release)? If so, are there any version limitations…

Azure Database for PostgreSQL
asked 2025-11-07T15:22:46.5566667+00:00
Nandhana Pramod Admin | Auro 0 Reputation points
commented 2025-11-13T14:14:40.38+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Create extension azure_storage fails with permission denied

Running CREATE EXTENSION IF NOT EXISTS azure_storage; against a new database on Azure Database for PostgreSQL flexible server (16.9) fails with ERROR: permission denied to alter restricted role "azure_pg_admin" The extension is on the allow…

Azure Database for PostgreSQL
asked 2025-11-10T12:14:16.0966667+00:00
Daniel Matthews 45 Reputation points
accepted 2025-11-12T16:03:10.22+00:00
Daniel Matthews 45 Reputation points
1 answer

The removed database still works.

I deleted the Postgres database and its resource group on August 29th (see the attached image), but it’s still working. I can’t find it anywhere in the Azure portal—what am I doing wrong?

Azure Database for PostgreSQL
asked 2025-09-04T04:51:53.2666667+00:00
Francesco Manzotti 0 Reputation points
commented 2025-11-12T05:12:57.37+00:00
Francesco Manzotti 0 Reputation points
1 answer

How to fix sudden POSTGRES database server connectivity issue and failing restart

My database server suddenly began refusing all connections, even in Azure portal. I tried to restart it through the portal UI and the operation failed. I then stopped the server and now it is stuck in "starting" for the last 30 minutes. This is…

Azure Database for PostgreSQL
asked 2025-11-04T16:51:31.23+00:00
InnovativeBPS 0 Reputation points
edited an answer 2025-11-11T09:46:09.8033333+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator