Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,253 questions
1 answer
Unable to create Azure Database for Postgres Flexible Server using terraform script due to Internal Server Error.
Hello everyone, I'm unable to create an azurerm_postgresql_flexible_server resource using terrafrom script. I'm getting following error: user@host:~/infra$ terraform apply tfplan.terraform azurerm_postgresql_flexible_server.postgressrv:…
asked 2025-03-07T08:50:48.3566667+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(12.8, 86%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shubham Kumar (iDEAS-Group)
0
Reputation points
edited a comment 2025-03-14T07:41:23.7633333+00:00
Shubham Kumar (iDEAS-Group)
0
Reputation points
0 answers
How to recover a deleted Azure Postgresql server in Azure US Government Cloud?
We accidentally deleted an Azure PostgreSQL Flexible Server that was still being used by one of our legacy services. I’ve already gone through the steps outlined in the official Microsoft documentation: "Restore a dropped Azure Database for…
asked 2025-03-13T11:04:16.58+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(96, 16%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sachin Vettiyattil
21
Reputation points
commented 2025-03-14T04:27:31.36+00:00
Sachin Vettiyattil
21
Reputation points
1 answer
Azure Database for PostgreSQL flexible server with Storage autogrow enabled, yet the server ran out of storage and became read-only.
I have an Azure Database for PostgreSQL flexible server with Storage autogrow enabled, yet the server ran out of storage and became read-only.
asked 2025-03-13T15:55:33.4966667+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(60.8, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cosmin Robert Lungu
0
Reputation points
commented 2025-03-14T03:35:31.3133333+00:00
Vinodh247
29,781
Reputation points MVP
1 answer
Maximum QPS for Azure PostgreSQL Flexible Server
Is there a dependency between the maximum queries per second that Azure PostgreSQL Flexible Server can support and the compute SKU of the flexible server?If not what are the factors affecting maximum queries per second that azure postgres flexible server…
asked 2025-03-11T22:08:47.8066667+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, 92%, 36%)' 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)
Sai
0
Reputation points
commented 2025-03-13T21:21:45.9433333+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(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
80
Reputation points Microsoft External Staff
1 answer
Shut down Azure PostgreSQL without Azure restarting it automatically
I created an Azure PostgreSQL database and when I shut it down I don't want it to restart automatically, how to fix that? This is what I get every time I shut down the database:
asked 2025-03-10T21:58:24.8033333+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(60.8, 78%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pablo Schor
0
Reputation points
commented 2025-03-13T21:17:50.82+00:00
Prasad Chaganti
80
Reputation points Microsoft External Staff
0 answers
PG Flexi Server is showing in updating state from past 7 days.
I changed the configuration of my Postgres Flexible server from D4s to D2s and it is showing in updated state since then.
asked 2025-03-13T15:22:21.78+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(179.20000000000002, 82%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Harsh Mittal
0
Reputation points
commented 2025-03-13T21:00:05.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(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
3,085
Reputation points Microsoft External Staff
3 answers
One of the answers was accepted by the question author.
Azure database for Postgres Flexible server - Why creating extension uuid-ossp requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server (version PG16). I tried to create extension on current database (logged into database as db owner) however I see an error stating "ERROR: Only members of…
asked 2024-10-30T10:51:45.6933333+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(262.40000000000003, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tulsiraja Shastry
20
Reputation points
edited a comment 2025-03-13T19:05:25.36+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(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBE%3C/text%3E%3C/svg%3E)
Bernd E
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Access to database stopped on Azure Database for PostgreSQL flexible server
Since a few hours ago our main flexible DBaaS server stopped working. From the resource health logs this was due to a very early in the morning schedule maintenance for Azure Database for PostreSQL. The message reads that the maintenance is taking longer…
asked 2025-03-11T13:44:52.3733333+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(262.40000000000003, 86%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Stavros Machairidis
20
Reputation points
accepted 2025-03-13T11:42:54.84+00:00
Stavros Machairidis
20
Reputation points
0 answers
Issues Connecting to PostgreSQL Flexible Server in Azure VPC with Terraform
Deploying a PostgreSQL Flexible Server inside a VPC using Terraform has been successful, but there is an issue with connecting via Point-to-Site VPN. After following the instructions listed here, connection attempts still fail. Attempts to resolve the…
asked 2025-01-28T01:15:27.2633333+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(48, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
William Kelly
5
Reputation points
commented 2025-03-13T11:33:09.2233333+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff
1 answer
Cost estimation for Azure PostgreSQL Flexible Server with PGVector
What is the estimated cost for using Azure PostgreSQL Flexible Server with PGVector enabled, targeting a throughput of 50 Queries per second? Cost should also include serving 1M dataset inclusive of data/index storage, backup, compute resources. Any…
asked 2025-03-11T11:49:10.5466667+00:00
Sai
0
Reputation points
commented 2025-03-13T09:51:50.21+00:00
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff
0 answers
How can we connect on-prem java application to Azure Database for PostgreSQL - Flexible Server using access token( managed identity or entra id)
i have a Azure Database for PostgreSQL - Flexible Server. my azure webapp connects to database using system assigned managed identity. how can we connect one of my on prem java application to database using managed identity or entra id? How the…
asked 2025-03-12T11:38:21.4933333+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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kanhaiya Sharma
20
Reputation points
commented 2025-03-13T09:46:38.5966667+00:00
Kanhaiya Sharma
20
Reputation points
0 answers
PostgreSQL can't be connected by Power Apps
I am trying to setup a connection on Power Apps to PostgreSQL flexible servers on Azure. The network uses public access and allows all IPs on the PostgreSQL firewall. I get an error related to credentials when setting up a PostgreSQL connection on Power…
asked 2025-03-13T03:18:03.73+00:00
Irvanda
116
Reputation points
edited a comment 2025-03-13T08:58:08.94+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,251
Reputation points
0 answers
Actual Backup Cost and Compression Ratio in Azure Database for PostgreSQL
The Azure Pricing Calculator provides an estimated backup cost per GB, but I would like to understand how I can determine the actual backup cost for my Azure PostgreSQL Flexible server. Additionally, I would like to know the backup compression ratio…
asked 2025-03-12T11:21:06.57+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(160, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Azeem, Muhammad
10
Reputation points
commented 2025-03-13T08:50:29.6933333+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, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Adithya Prasad K
90
Reputation points Microsoft External Staff
0 answers
Azure scheduled auto migration from postgresql single server to flexible server is stuck 'in progress' status for 23 hours
Hello, I had a scheduled auto migration from Postgresql single server to flexible server. It has been stuck 'In Progress' status for last 23 hours. I have no idea what is going on in the background nor I can check the progress. I have the following…
asked 2025-03-07T12:37:05.3233333+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(64, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jayabharathi Nagaraj
0
Reputation points
edited a comment 2025-03-13T08:10:39.6433333+00:00
Jayabharathi Nagaraj
0
Reputation points
0 answers
Azure Database for PostgreSQL flexible server stuck in restart
The server got stuck in restart and the question what to do now besides delete and recreate. Any other way to get to this server?
asked 2025-03-05T12:19:14.4366667+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(124.80000000000001, 73%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Francis Antonietti
10
Reputation points
commented 2025-03-13T05:21:44.67+00:00
ShaktiSingh-MSFT
16,251
Reputation points
1 answer
Error migrating from single to flex postgres
After 16h in online migration the process failed with the following error: DB004: Failed to fetch the current migrations status. Please reference MigrationId 3691c83d-e8ba-4fca-a612-88fd534ed620, when contacting Microsoft customer support. Parameter…
asked 2025-02-13T17:03:57.81+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, 28.000000000000004%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Dias
5
Reputation points
commented 2025-03-13T05:02:45.9933333+00:00
ShaktiSingh-MSFT
16,251
Reputation points
0 answers
First time (admin) login to private Postgres Flexible Server with EntraID enabled
First time (admin) login to private Postgres Flexible Server with EntraID enabled Dear Community, I have created a Postgres Flexible Server, private (with VNET assigned) and only EntraID authentication enabled. My user is the admin. Now, since I cant use…
![](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(64, 9%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
![](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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
Can't we reduce the postgres storage once upgraded ?
Hello , I have an postgres deployed on my azure env but from the past couple of months we have been facing storage issues hence we are trying to downgrade the storage as we fixed the code and but I don't see the option of previous storage like earlier…
asked 2025-03-12T06:07:46.48+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(310.4, 62%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ReCloudS
80
Reputation points
commented 2025-03-13T01:26:17.5766667+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(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi
95
Reputation points Microsoft External Staff
1 answer
Azure App Service can't connect to PostgreSQL Flexible server
The firewall rules for Azure PostgreSQL Flexible server are not being applied. We are constantly getting 28000: pg_hba.conf rejects connection for host "xx.xx.xx.xx". Although for testing purposes we have allowed any IP-Address. It is still…
asked 2025-03-04T07:30:24.99+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(89.60000000000001, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Ben Luts
0
Reputation points
commented 2025-03-12T19:49:35.3366667+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
2 answers
How to delete a resource that is billed but cannot be found
We get billed for a resource that we do no longer need and want to delete, but cannot delete, as the resource is not found.
asked 2025-03-11T09:48:47.78+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(310.4, 92%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marco Waimer
0
Reputation points
commented 2025-03-12T18:46:56.7633333+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee