Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,249 questions
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…
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
2 answers
Unsupported server parameter after Azure flexible PostgreSQL server upgrade v11 to v13
We performed a PostgreSQL version upgrade (v11 -> v13) and cannot change any server parameter via the GUI nor via CLI anymore. The error is: (ParameterNotExists) The Parameter [azure.allow_hostname_in_username] is invalid or unsupported in current PG…
asked 2025-02-24T14:13:58.47+00:00
Johannes Boyne
21
Reputation points
commented 2025-03-12T17:32:42.06+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
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
answered 2025-03-12T17:02:27.0133333+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
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
0
Reputation points
commented 2025-03-12T16:35:48.2733333+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,005
Reputation points Microsoft External Staff
1 answer
How to add pgaadauth in azure pg flexible servers it is always giving error,Also how to add pg_cron to a db
CREATE EXTENSION IF NOT EXISTS pgaadauth; ERROR: extension "pgaadauth" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL HINT: to learn how to allow an extension or see the list of allowed extensions,…
asked 2025-01-31T09:41:54.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(48, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aditya Singh
0
Reputation points
commented 2025-03-12T14:35:58.0966667+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
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-12T14:00:32.0333333+00:00
João Paulo Ferreira de Souza
0
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-12T13:41:12.7266667+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-12T13:19:35.49+00:00
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff
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-12T12:36:15.29+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
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-12T12:00:45.1833333+00:00
Shubham Kumar (iDEAS-Group)
0
Reputation points
2 answers
One of the answers was accepted by the question author.
org.postgresql.util.PSQLException: FATAL: Service Principal oid mismatch for role[username]. when connecting azure postgresSQL from azure webapp
I am receiving below error when i try to connect my java application to azure postgresql using azure user created managed identity. INFO: Retrieving Azure AD access token... SLF4J: Failed to load class…
asked 2025-02-14T15:41:00.85+00:00
Kanhaiya Sharma
20
Reputation points
accepted 2025-03-12T11:11:22.36+00:00
Kanhaiya Sharma
20
Reputation points
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
![](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-12T09:42:35.48+00:00
Vijayalaxmi Kattimani
1,720
Reputation points Microsoft External Staff
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
edited the question 2025-03-12T06:26:32.87+00:00
Andreas Baumgarten
118.9K
Reputation points MVP
0 answers
My Azure Database PostgreSQL resources disappeared
Hi, Hope everything is going well. I've trying to access my PostgreSQL resources in Azure Portal but I cannot find them. I've read that Microsoft Azure is not supporting the creation of single server but I don't know why I cannot see them in my portal.…
asked 2025-03-05T01:08:51.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(169.60000000000002, 3%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETI%3C/text%3E%3C/svg%3E)
techko-it
0
Reputation points
edited a comment 2025-03-12T04:54:16.68+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
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)
0 answers
Unable to Change Ownership of cron Table in Azure PostgreSQL
Dear Team, I am experiencing an issue with Azure Database for PostgreSQL - Flexible Server, where I am unable to change the ownership of the cron table. The table is currently owned by azuresu and due to Azure's restricted SUPERUSER access, I cannot…
asked 2025-03-09T15:31:03.0266667+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(153.6, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ahmed Gamal
0
Reputation points
commented 2025-03-12T01:43:47.4633333+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
Connection DoesNotExistsError:connection was closed in the middle of operation
Hi, Users are complaining "Connection DoesNotExistsError:connection was closed in the middle of operation" error while using a streamlit UI based web app deployed on Azure. Thanks for help!
asked 2025-02-26T12:19:59.53+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(163.2, 27%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Humankind
0
Reputation points
commented 2025-03-11T19:46:33.9233333+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
0 answers
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-11T19:19:50.76+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