Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
1 answer
How to fix PostgresQL Flexible Server with Postgres 17.4 that has been down since Scheduled Maintenance 2025-07-08
Postgres 17.4 Flexible Server has been inaccessible since the scheduled maintenance that occurred on 2025-07-08. The server has zero availability, all previously connected and new connections are refused. Server will not respond to any Restart or Stop…
Azure Database for PostgreSQL
asked 2025-07-10T15:27:52.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 14.000000000000002%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jordan
0
Reputation points
commented 2025-07-14T16:37:39.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
5,540
Reputation points Microsoft External Staff
Moderator
0 answers
Maintain privilege in postgresql flexible server
Hi! I'm using Azure Database for PostgreSQL Flexible Server (version 16.8), and I'm trying to grant the MAINTAIN privilege on a table, which is supported in PostgreSQL 14+. However, I'm getting an error: unrecognized privilege type…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-11T11:19:43.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Staffan Hedström - HMS
100
Reputation points
commented 2025-07-14T11:05:51.7166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
0 answers
Start operation is only supported on servers that are in 'Stopped' state. Server 'la-ssp-psql-dev' is in 'Ready' state.
Since friday july 11, we are getting this errors in our postgresql servers: (ServerIsNotStopped) Start operation is only supported on servers that are in 'Stopped' state. Server 'la-ssp-psql-dev' is in 'Ready' state. Code: ServerIsNotStopped Message:…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-14T10:24:06.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 24%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gediminas
0
Reputation points
edited the question 2025-07-14T10:32:51.2033333+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
How will retiremenet of default outbound access affect Azure Database for PGFS
Hello, we are trying to understand how retirement of default outbound access will affect our applications. As I understand, default outbound access is used always when a VM in Azure doesn't have any public IP address associated. Right now we are testing…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-14T05:47:41.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
BITNI SAIF KHAN (Experis IT Private Limited)
20
Reputation points Microsoft External Staff
accepted 2025-07-14T08:16:45.1+00:00
BITNI SAIF KHAN (Experis IT Private Limited)
20
Reputation points Microsoft External Staff
0 answers
PostgreSQL Flexible Server Unplanned Downtime Misclassified as Customer Initiated – Need RCA
An Azure Database for PostgreSQL – Flexible Server instance experienced an extended unplanned downtime on July 11, 2025 (approximately 12 hours). The Azure Resource Health dashboard reports the following: Status: Unavailable (Unplanned) Reason:…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-14T07:14:35.5933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 20%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VS
0
Reputation points
commented 2025-07-14T07:19:30.8633333+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
2 answers
Create Postgres error Subscription Microsoft Azure Sponsership is not allowed to provision in 'East US'.
While attempting to create a resource (e.g., a server or database) in the East US region under the Microsoft Azure Sponsorship subscription, Azure displays the following error: Subscription 'Microsoft Azure Sponsorship' is not allowed to provision in…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
999 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-11T14:36:27.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 90%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Josh H
0
Reputation points
commented 2025-07-11T21:21:12.05+00:00
Oury Ba-MSFT
20,936
Reputation points Microsoft Employee
Moderator
1 answer
I can't connect to my database
URGENT: Unable to Access Azure PostgreSQL Flexible Server (db-morefm-restore) – All Services Down I am reaching out for urgent assistance regarding a critical issue with our Azure PostgreSQL Flexible Server instance: db-morefm-restore. Since his…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-07T15:31:50.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Axel Ramírez
0
Reputation points
commented 2025-07-11T16:53:32+00:00
Mahesh Kurva
5,540
Reputation points Microsoft External Staff
Moderator
0 answers
Inconsistent behavior on Azure Postgres Flexible Servers with the same version - scenario 1
Hello, I am seeing different results in the pg_auth_members system table after running identical role and grant statements on two Azure PostgreSQL Flexible Servers (version 16.9), deployed a week apart. The two servers have strictly the same explicit…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-11T11:18:30.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 7.000000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ioana Teodorescu
0
Reputation points
commented 2025-07-11T13:30:03.7533333+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
0 answers
Inconsistent behavior for DROP ROLE IF EXISTS on Azure Postgres Flexible Servers with the same version - scenario 2
Hello, Today, I deployed several azure postgresql flexible servers (16.9) and I notice that I cannot run anymore a DROP ROLE IF EXISTS toto, if the role toto does not exist. This is supposed to work in Postgres 16 (actually, at least since version 13)…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-11T11:31:00.4+00:00
Ioana Teodorescu
0
Reputation points
commented 2025-07-11T12:20:31.1533333+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
0 answers
Azure Database for PostgreSQL flexible server Connection Issue all of a sudden
Hi there, Last night around 11:37 the database went down all of a sudden after running for over a year. Connections all died and I can not view any of the databases on the server. I cant get ahold of anyone that can look into it for me. There is a…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-09T06:38:51.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gareth Glanville
0
Reputation points
commented 2025-07-11T03:24:45.5033333+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Upgrade stuck on PostgreSQL
Dear, We experienced issue 1 day ago with accessing our PostgreSQL Flexible Server through Private Endpoint, our other databases that work through the same networking were working without any issues. There were no blockings from NSG side or anything…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-10T12:01:20.5966667+00:00
Goran Kuga
20
Reputation points
commented 2025-07-10T15:03:05.3+00:00
Goran Kuga
20
Reputation points
2 answers
Unable to upgrade postgres version 15 to 16
Hi, I'm trying to upgrade postgres version 15 to 16 but it comes with an error message: { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2024-04-10T21:24:25.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
TIen Vo
5
Reputation points
answered 2025-07-10T09:07:38.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 28.999999999999996%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sinem Bayir
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Why can't I locate my Azure Database for PostgreSQL – Single Server instance in the Azure portal, even though I can access it via a connection string, and how does the scheduled retirement by March 28, 2025, affect this?
I am unable to find my Azure Database for PostgreSQL – Single Server instance in the Azure portal, even though I can successfully connect to it using a connection string (e.g., host=yourservername.postgres.database.azure.com). I understand that Single…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 52%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
PostgreSQL services disappeared after migration to flexible server
Dear all, As I have seen, I'm not the first one with this problem - after migration to the flexible server my Azure Database for PosrtgreSQL has disappeared from the portal and resource group (and CLI / Powershell). The database is still working fine,…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-01T19:12:02.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 74%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tomislav Tipuric
20
Reputation points
accepted 2025-07-09T14:41:45.5233333+00:00
Tomislav Tipuric
20
Reputation points
2 answers
One of the answers was accepted by the question author.
PostgreSQL flexible server, DB unavailable
This morning our DB on an Azure Database for PostgreSQL flexible server (Burstable, B2s, 2 vCores, 4 GiB RAM, 32 GiB storage) became unavailable, without any action made by us. Looking at the Activity Logs, I can see a "Health Event…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Message: Restart and stop operations are only supported on servers that are in 'Ready' state. Server 'xxx' is in 'Ready' state.
Hi, I have a Azure PostgreSQL Flexible database, and at 11:30 pm GMT+2 it lost connection to our app service, we cannot restart the database as it gives the following error: Message: Restart and stop operations are only supported on servers that are in…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-09T07:48:03.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Matthew Ethan Tam
20
Reputation points
commented 2025-07-09T13:36:55.5333333+00:00
Matthew Ethan Tam
20
Reputation points
1 answer
Unable to increase postgres flexible server plan
Hi, I’ve tried several times via the Azure Portal and to scale server erp-api-dev-postgres3 from B2ms (2 vCores, 4 GiB) to Standard_D4ds_v5 (4 vCores, 16 GiB, 6400 max IOPS). Each attempt sits in Updating for a few minutes and then flips to Failed with…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-06-12T15:09:19.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 62%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Atramentum
0
Reputation points
commented 2025-07-09T01:49:27.7533333+00:00
Atramentum
0
Reputation points
0 answers
Azure PostgreSQL Database Unresponsive – Failing Upgrade, Restart, and Scaling Operations
We are experiencing a critical issue with our Azure Database for PostgreSQL. The database has become extremely slow, and all attempts to remediate the situation have failed. Specifically: Application is unresponsive due to severe database…
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-07T15:16:02.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 32%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mihajlo Milijic
0
Reputation points
commented 2025-07-08T19:03:15.4266667+00:00
Mahesh Kurva
5,540
Reputation points Microsoft External Staff
Moderator
3 answers
How to investigate Unavailability of Azure Database for PostgreSQL Flexible Server
How to investigate unavailability of Azure Database for PostgreSQL Flexible Server
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-08T13:01:23.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
ZTS
20
Reputation points
answered 2025-07-08T13:23:34.25+00:00
Saraswathi Devadula
7,570
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
az postgres flexible-server firewall-rule delete returns InternalServerError
Hello, I am trying to delete a firewall rule from my Azure PostgreSQL Flexible Server using the Azure CLI command: az postgres flexible-server firewall-rule delete \ --resource-group <resource-group-name> \ --name <server-name> \ …
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,450 questions
asked 2025-07-07T14:53:49.4233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 83%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mark Knotzer
20
Reputation points
accepted 2025-07-08T12:17:08.8033333+00:00
Mark Knotzer
20
Reputation points