1,893 questions with Azure Database for PostgreSQL tags

Sort by: Updated
2 answers

Our Development server DB suddenly disappeared for no apparent reason

Our Development server DB suddenly disappeared for no apparent reason. We see that there was some maintenance scheduled for the service and we were wondering if this had something to do with it? We want to make sure it's not an issue with the actual…

Azure Database for PostgreSQL
asked 2026-04-07T17:39:48.9466667+00:00
Peter Lamming 0 Reputation points
answered 2026-04-07T19:47:14.1533333+00:00
Manoj Kumar Boyini 11,355 Reputation points Microsoft External Staff Moderator
1 answer

Connection Timeouts to azure postgresql database

We’re encountering errors in our ADF pipelines when attempting to connect to the Azure PostgreSQL database. At the time, we were running 20 child pipelines concurrently. We can provide you the end point.   Error code 2100 Failure type User…

Azure Database for PostgreSQL
asked 2026-04-07T13:46:40.1733333+00:00
Bobby John 60 Reputation points
answered 2026-04-07T19:33:04.2633333+00:00
David Broggy 6,796 Reputation points MVP
2 answers

Azure Database for PostgreSQL flexible server - Upgrade unavailable due to regional capacity constraints

Using Azure Database for PostgreSQL flexible server v17.6 The upgrade option to v18 is disabled and indicates: Upgrade unavailable due to regional capacity constraints. Contact support to discuss alternative options. How to resolve?

Azure Database for PostgreSQL
asked 2026-03-31T03:46:53.1366667+00:00
John 0 Reputation points
answered 2026-04-07T15:28:33.38+00:00
SAI JAGADEESH KUDIPUDI 1,600 Reputation points Microsoft External Staff Moderator
2 answers

Postgresql upgradation from 16 to 18

Trying to upgrade the postgresql from 16 to 18. Can you help us here ? Error as below: { "code": "MajorVersionUpgradeFailedPrecheck", "message": "The major version upgrade failed precheck. Upgrading extension…

Azure Database for PostgreSQL
asked 2026-03-30T15:05:18.95+00:00
Bobby John 60 Reputation points
edited a comment 2026-04-07T15:12:56.5233333+00:00
SAI JAGADEESH KUDIPUDI 1,600 Reputation points Microsoft External Staff Moderator
2 answers

Cannot increase storage on Azure Database for PostgreSQL Flexible Server — InternalServerError and "location is restricted for provisioning"

We are unable to increase storage on our production PostgreSQL Flexible Server. The database is nearly full and customer applications are at risk. Server details: - Server name: pg-dxc - Resource Group: dexie-cloud - Region: East US - Current tier:…

Azure Database for PostgreSQL
asked 2026-04-07T12:33:49.4433333+00:00
David Fahlander 0 Reputation points
commented 2026-04-07T14:24:59.36+00:00
David Fahlander 0 Reputation points
1 answer

pg_diskann PQ mode causes TOAST corruption during vector insert (possibly after deleting items and index rebuild doesnt work correctly)

During vector ingestion with pg_diskann Product Quantization (PQ) enabled, multiple TOAST values become corrupted in pg_toast_27911. Error: Failed to store final vector batch: missing chunk number 0 for toast value 469475 in pg_toast_27911 Affected…

Azure Database for PostgreSQL
asked 2026-04-04T23:18:25.3533333+00:00
Geoff Fletcher 0 Reputation points
commented 2026-04-07T08:09:18.13+00:00
Saraswathi Devadula 15,515 Reputation points Microsoft External Staff Moderator
0 answers

Azure Database for PostgreSQL Flexible Server (Australia East) has been stuck in "Updating" state for over 4 hours since approximately 08:35 UTC on April 6, 2026

My production Azure Database for PostgreSQL Flexible Server has been stuck in "Updating" state for over 4 hours and I cannot perform any operations on it. Resource details: Region: Australia East SKU: Burstable B2s PostgreSQL version:…

Azure Database for PostgreSQL
asked 2026-04-07T06:19:56.6566667+00:00
Mohamed Abdelaziz 0 Reputation points
commented 2026-04-07T06:41:24.3466667+00:00
SAI JAGADEESH KUDIPUDI 1,600 Reputation points Microsoft External Staff Moderator
2 answers

Azure Database for PostgreSQL Flexible Server (Australia East) has been stuck in "Updating" state for over 4 hours since approximately 08:35 UTC on April 6, 2026. No u

My production Azure Database for PostgreSQL Flexible Server has been stuck in "Updating" state for over 4 hours and I cannot perform any operations on it. Resource details: Region: Australia East SKU: Burstable B2s PostgreSQL version:…

Azure Database for PostgreSQL
asked 2026-04-06T17:37:53.92+00:00
Mohamed Abdelaziz 0 Reputation points
commented 2026-04-07T05:42:45.78+00:00
Mohamed Abdelaziz 0 Reputation points
3 answers

My PostgreSQL single server disappeared after automatic migration?

Hello, my Azure Database for PostgreSQL single server should have been migrated to Azure Database for PostgreSQL flexible server. The the automatic migration took over 1 week. The scheduled time for migration start was 9/4/2024. Yesterday the…

Azure Database for PostgreSQL
asked 2024-09-12T06:58:51.29+00:00
Fabian Schmidt 50 Reputation points
commented 2026-04-06T22:55:40.9933333+00:00
Mohamed-Laid 0 Reputation points
0 answers

PostgreSQL database set up with Azure

I have created my Web App with Azure and now want to bring my PostgreSQL database over to Azure. When I try to subscribe and set up an Azure PostgreSQL database, I get to the final step and click 'Create' but the operation just hangs and the Validate…

Azure Database for PostgreSQL
asked 2026-03-17T07:32:38.7133333+00:00
Jacqui Power 0 Reputation points
edited a comment 2026-04-06T12:24:21.62+00:00
SAI JAGADEESH KUDIPUDI 1,600 Reputation points Microsoft External Staff Moderator
1 answer

How to fix -Azure Database for PostgreSQL - Flexible server is currently unavailable.

STUCK FOR THREE DAYS [my-db-server] is being affected by a resource health event. Status: Last update: Unavailable Your Azure Database for PostgreSQL - Flexible server is currently unavailable. We are working to resolve the problem. Just this message…

Azure Database for PostgreSQL
asked 2026-03-09T07:02:17.4166667+00:00
niranjan 0 Reputation points
edited a comment 2026-04-06T10:52:37.95+00:00
Saraswathi Devadula 15,515 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

pg_textsearch extension support on Azure Database for PostgreSQL

Are there any plans to add support for the pg_textsearch extension (https://github.com/timescale/pg_textsearch) to Azure Database for PostgreSQL? This extension offers advanced full-text search capabilities that would be highly beneficial for users who…

Azure Database for PostgreSQL
asked 2026-02-04T11:35:19.82+00:00
Miguel Silva 35 Reputation points
commented 2026-04-06T04:43:51.28+00:00
Nguyen, Bao-Khang 0 Reputation points
1 answer

Azure PostgreSQL Flexible Server stuck in "Updating" state for 7+ hours after planned maintenance

Hello, My Azure Database for PostgreSQL Flexible Server has been stuck in an "Updating" state for over 7 hours following scheduled maintenance. Server Details Server name: orcana-dev Resource group: orcana Region: East US (Availability Zone…

Azure Database for PostgreSQL
asked 2026-03-31T17:17:45.9933333+00:00
Reehan Shah 0 Reputation points
commented 2026-04-03T21:46:20.77+00:00
Pilladi Padma Sai Manisha 6,430 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Major version upgrade (14 to 18) hangs indefinitely - dblink_fdw / PgBouncer foreign server blocking pg_upgrade

Problem In-place major version upgrade from PostgreSQL 14.20 to 18 on Azure Database for PostgreSQL Flexible Server hangs indefinitely. The upgrade never begins — the server stays online at version 14 and is never taken offline for pg_upgrade. Region:…

Azure Database for PostgreSQL
asked 2026-04-01T14:31:13.1433333+00:00
Bob Binckes 25 Reputation points
commented 2026-04-03T14:22:07.8866667+00:00
Bob Binckes 25 Reputation points
0 answers

Cannot read properties of undefined (reading 'createdAt')

The deployment of my azure resource is stuck. The deployment will not complete and the resource is not visible on the CLI.

Azure Database for PostgreSQL
asked 2026-04-03T09:04:54.2866667+00:00
Nick Allair 0 Reputation points
commented 2026-04-03T09:40:49.4033333+00:00
Manoj Kumar Boyini 11,355 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Error when creating a virtual endpoint on postgresql

plan. Resource actions are indicated with the following symbols: + create Terraform will perform the following actions: # module.postgresql.azapi_resource_action.virtual_endpoint will be created + resource "azapi_resource_action"…

Azure Database for PostgreSQL
asked 2026-04-01T09:25:58.9533333+00:00
Maddy 25 Reputation points
accepted 2026-04-02T08:13:02.04+00:00
Maddy 25 Reputation points
0 answers

PG Flexible Server - Getting timestamp for latest restore point (now)

Hello, We've recently tested restoring an Postgresql Flexible server from the Azure portal, but when we chose the option for "latest restore point (now)", we realized we don't get to know the timestamp that it's using to restore the…

Azure Database for PostgreSQL
asked 2026-03-23T08:22:36.08+00:00
Veruska 10 Reputation points
commented 2026-04-01T22:11:33.9366667+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
3 answers

I need help removing a Postgres SQL Resource

The Postgres SQL server was not properly created and is in an errored state. I'm not able to remove it. I created a new one which seems to be ok:

Azure Database for PostgreSQL
asked 2026-03-24T16:33:18.0233333+00:00
Adam Hong 0 Reputation points
commented 2026-04-01T01:21:12.75+00:00
Saraswathi Devadula 15,515 Reputation points Microsoft External Staff Moderator
1 answer

We are unable to deploy a flexible server database to US east

We are on Microsoft Azure Sponsorship and are unable to deploy a database to US East which is a data residency requirement for one of our deployments. Can we get our account access to do this?

Azure Database for PostgreSQL
asked 2026-03-31T23:50:50.8066667+00:00
Michael Cowling 20 Reputation points
answered 2026-04-01T00:29:23.9566667+00:00
Pilladi Padma Sai Manisha 6,430 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

App service cannot connect to postgresql

I have deployed a web app running ( next.js + payload + cms). A postgresql database which is placed inside a VNet and no public access. The secrets are stored in key vault and app service managed identity has permissions to read secrets from key vault.…

Azure Database for PostgreSQL
asked 2026-03-31T20:16:52.93+00:00
ahd 270 Reputation points
answered 2026-03-31T21:57:03.51+00:00
Pilladi Padma Sai Manisha 6,430 Reputation points Microsoft External Staff Moderator