Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,247 questions
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…
![](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)
![](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
40
Reputation points
edited the question 2025-03-12T06:26:32.87+00:00
Andreas Baumgarten
118.9K
Reputation points MVP
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
commented 2025-03-12T05:05:19.9433333+00:00
Shubham Kumar (iDEAS-Group)
0
Reputation points
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-12T04:58:01+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
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
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)
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
0 answers
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-12T00:42:11.47+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
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-11T22:30:11.57+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
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-11T22:21:49.2366667+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
2,920
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
Prasad Chaganti
80
Reputation points Microsoft External Staff
1 answer
Unable to Create Azure Database for PostgreSQL Flexible Server in Germany West Region
Attempting to migrate an Azure Database for PostgreSQL Single Server to a Flexible Server as outlined in the migration tutorial. The first step is to create the new Flexible Server using the same configuration as the existing single server. However, when…
asked 2025-03-06T15:11:45.9566667+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(128, 40%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sarah Langheinrich
0
Reputation points
commented 2025-03-11T16:29:24.0333333+00:00
Mahesh Kurva
2,920
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
answered 2025-03-11T13:47:59.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(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,645
Reputation points Microsoft External Staff
0 answers
Cannot Drop Role with "Replication" Attribute in Azure PostgreSQL Flexible Server 16
Hello, I am encountering the following error when trying to drop a role that has the "REPLICATION" attribute enabled. ERROR: permission denied to drop role Detail: Only roles with the CREATEROLE attribute and the ADMIN option on role…
asked 2025-03-06T19:29:17.0533333+00:00
Gabriel Aquino
0
Reputation points
commented 2025-03-10T19:23:32.13+00:00
Prasad Chaganti
80
Reputation points Microsoft External Staff
3 answers
Requesting support for Apache AGE extension on Azure PostgreSQL
Is it possible to request support for the Apache AGE extension on Azure PostgreSQL databases? I'm curious if Microsoft has a request system similar to AWS.
asked 2024-01-25T03:10:38.2133333+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(240, 67%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jessica Wang
10
Reputation points
answered 2025-03-10T18:51:58.1666667+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(105.60000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Joshua Johnson
0
Reputation points
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
commented 2025-03-10T14:00:39.18+00:00
Jayabharathi Nagaraj
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Efficiently Exporting Recent Data from a TimescaleDB Table with 60K Chunks (150M Rows)
Hello, I am running a TimescaleDB inside a VM and need to export data from a hypertable. The table contains approximately 150 million rows and around 60,000 chunks. Whenever I run a query to export data, the psql session stops due to the large…
asked 2025-03-08T14:28:01.3+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(300.8, 5%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
KriShna PrakaSh
20
Reputation points
edited a comment 2025-03-10T10:45:16.37+00:00
KriShna PrakaSh
20
Reputation points
0 answers
The server is currently in 'starting' 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.
Azure Database for PSQL unable to start from stopped state. With warning message: The server is currently in 'starting' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is…
asked 2025-03-10T01:30:57.1266667+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(192, 71%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Edcel
0
Reputation points
commented 2025-03-10T09:15:01.11+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
0
Reputation points Microsoft External Staff
1 answer
Postgres DB ran out of connections and now won't start
We had an out of control process create a bunch of connections to our Postgres db. After that we were unable to connect to that database. So, we tried stopping the database. Now it is hung, and we can't stop nor start it. Any help?
asked 2025-03-06T21:39:01.7733333+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(156.8, 76%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Josh Knepfle
0
Reputation points
commented 2025-03-10T08:29:06.72+00:00
Saraswathi Devadula
0
Reputation points Microsoft External Staff