Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
921 questions
0 answers
Azure Data Studio with PostgreSQL connection type cannot connect to server
Hello, I'm currently trying to connect to a server via a PostgreSQL connection on Azure Data Studio. I installed the app from the official webpage and then added the PostgreSQL extension via the app extensions interface. I have copied a configuration…
asked 2024-06-28T14:33:01.2333333+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(118.4, 82%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Ludovic Arnould
0
Reputation points
commented 2024-06-28T19:27:51.9633333+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
Error while creating new indexes on Azure database
Hello The migration from on premise to Azure has been done with success with all the metadata and data the 18/06/2024. It included indexes. At this time we had no errors. Now we want to try to create new BTREE indexe on our database but it fails with the…
asked 2024-06-28T08:24:28.7133333+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, 41%, 10%)' 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)
JOLY, Josselin (ITOP CD) - AFKL
0
Reputation points
commented 2024-06-28T17:29:00.93+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
1 answer
Ability to grant admin user ADMIN option in Azure PostgreSQL Flexible Server version 16
I have created a new flexible server at version 16 with 2 admins: Postgres admin called "adminuser" Microsoft Entra admin called "entraadmin" (visible at Security - Authentication on portal) My use case is to transfer ownership…
asked 2024-06-26T23:13:59.75+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, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYT%3C/text%3E%3C/svg%3E)
Yichen Tian
0
Reputation points
commented 2024-06-28T15:26:20.24+00:00
Yichen Tian
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to delete an Azure Database for PostgreSQL flexible server
When attempting to delete an Azure Database for PostgreSQL Server, the error message "An error occurred deleting PostgreSQL server. Unknown error." is displayed. The resource is empty and there are no user databases. How can I resolve this…
asked 2024-06-15T08:42:59.8133333+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, 19%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Christian Hageraats
0
Reputation points
accepted 2024-06-28T10:41:16.1366667+00:00
Christian Hageraats
0
Reputation points
1 answer
getaddrinfo EAI_AGAIN error when connecting to Postgres DB
Hi, One of our team is getting the below error when their API hosted in AKS connecting to Postgres DB (Configured using Private endpoint). This error is generated at random requests, say in a day 50 requests fails due to this. I verified the internal…
asked 2024-06-19T07:02:24.04+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(38.4, 12%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ravichandran, Gopi Krishna
161
Reputation points
answered 2024-06-28T07:59:10.9766667+00:00
Ravichandran, Gopi Krishna
161
Reputation points
1 answer
Issues with Purview Scanning Azure Postgres instance
When scanning a Azure PostgreSQL instance - getting the following. We connect but are unable to scan. We are using a Sysadmin Postgres account for scanning. Here is the…
asked 2024-06-26T19:24:18.1533333+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(131.20000000000002, 69%, 22%)' 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)
Stephen Barry
0
Reputation points
edited the question 2024-06-27T03:56:44.7333333+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(233.6, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
ManoharLakkoju
690
Reputation points Microsoft Vendor
2 answers
Connection String to Grant Web App running .NET code access to PostgreSQL Flexible Server via Managed Identity
Hi, I need to deploy a webApp running .NET Code and Azure Database for PostgreSQL flexible server. Our policy is to grant webApps/functionApps access to SQL Server/MySql Server/PostgreSQL Server via Managed Identity. While, I can see connection strings…
Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
642 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,558 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
921 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,244 questions
asked 2024-06-11T13:04:40.8433333+00:00
84017655
1
Reputation point
answered 2024-06-26T15:32:10.8433333+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
i try to get the info in postgresql of the endpoint
i try to get the info of the endpoint by this sdk call : list(PostgreSQL(token, subscription_id).private_endpoint_connections.list_by_server("tommy","testtommy1")) the problem i get this as err: and the problem the endpoint info…
asked 2024-06-23T08:04:23.3666667+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, 56.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tommy Mordehay
0
Reputation points
edited a comment 2024-06-26T07:45:55.4033333+00:00
Tommy Mordehay
0
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.
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.
asked 2024-06-19T09:58:03.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(64, 90%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Buelah Karumuru
0
Reputation points
commented 2024-06-26T07:32:16.3533333+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
14,201
Reputation points Microsoft Employee
0 answers
I selected Storage Auto-growth option for my postgresql flexible server and then I restarted the server and since then the server is in 'restarting' state for 24 hours.
My Azure Postgresql Flexible Server has reached its storage limit, so I selected the Storage Auto-growth option. After 15 minutes nothing changed and I restarted the server. Since then, the server has been in 'restarting' state for 24 hours. Type of…
asked 2024-06-21T10:11:48.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(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 2024-06-26T06:30:33.0566667+00:00
Cosmin Robert Lungu
0
Reputation points
1 answer
Permission denied to ALTER DEFAULT PRIVILEGES
I'm trying to alter the default privileges of a role (roleB) that I am a member of, to allow it to modify objects created by another role (roleA) that I am also a member of. I have the inherit attribute set on my role. This is on a PostgreSQL 16 instance…
![](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(70.4, 11%, 16%)' 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)
4 answers
One of the answers was accepted by the question author.
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
asked 2023-08-11T08:12:39.71+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, 5%, 25%)' 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)
Pitawat
341
Reputation points
commented 2024-06-25T08:25:26.28+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, 55.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Christian Patry
5
Reputation points
2 answers
One of the answers was accepted by the question author.
I am using PostgreSQL server service on azure platform accidentally i have replaced my PostgreSQL server and all the data has been lost. The server has been recreated but the data is lost and the backups have been done from the date of new creation.
I am using PostgreSQL server service which is handled by terraform. Recently I have recreated the server and the databases inside it accidentally while making a few changes to the code. The server has been recreated but the data is lost. The backup is…
asked 2024-05-18T13:02:25.1166667+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, 33%, 14%)' 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)
mungi sai meghavardhan
20
Reputation points
accepted 2024-06-25T06:25:19.44+00:00
mungi sai meghavardhan
20
Reputation points
1 answer
Azure Database for PostgreSQL flexible server Is not getting Started
Azure Database for PostgreSQL flexible server Is not getting Started. and server is currently in starting state. And getting below waring massage in portal: "The server is currently in 'starting' state. Please wait for the operation to complete.…
asked 2024-06-19T13:08:16.8833333+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, 80%, 34%)' 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)
Srinivas Bhimireddi
0
Reputation points
answered 2024-06-24T22:28:39.7466667+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
1 answer
PosgresQL flexible status "starting"
El día de hoy 19 de junio 2024, el inicio diario automatizado del server flexible se quedó en status "starting"; ya tiene varias horas en ese status. Por comandos de azure client, marca errorer al intentar, detener, iniciar y reiniciar. An…
asked 2024-06-19T18:50:58.1066667+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(217.60000000000002, 94%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Erick Salazar
0
Reputation points
commented 2024-06-24T19:11:15.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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,011
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
track_commit_timestamp server parameter in Azure Database for PostgreSQL flexible server
I see that track_commit_timestamp server parameter is disabled by default in Azure Database for PostgreSQL flexible server, I would like to know if there is any performance issue if I enable it.
asked 2024-05-15T11:17:18.27+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(25.6, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
181
Reputation points
accepted 2024-06-23T02:44:50.1133333+00:00
Naveen Kumar Kakarla (Quadrant Resource)
181
Reputation points
1 answer
How to Publish PowerBI report with Azure PostGres flexible server Database
I have created Power BI report connecting MS Postgres Flexible server on prem using Vnet . But when I am publishing it is on Cloud it is giving us error or not able to connect,
asked 2024-06-20T12:21:48.9633333+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, 57.99999999999999%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajeev Kumar Dave
21
Reputation points
answered 2024-06-21T21:00:29.22+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
1 answer
ORM Support for Azure Database for Postgresql - felxible server
Do we have support to ORM using NodeJS for Azure Database for Postgresql - felxible server?
asked 2024-06-18T08:05:47.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(163.2, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gumudavelli, Dheeraj /IN
0
Reputation points
answered 2024-06-21T04:50:42.6+00:00
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
0 answers
appservice changing method as GET instead of POST
DMZ API changing method as GET instead of POST
asked 2024-06-20T17:02:42.8166667+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(195.2, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Paras Gandhi
0
Reputation points
edited the question 2024-06-21T01:14:19.67+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, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT
28,126
Reputation points Microsoft Vendor
0 answers
Connect and query to Azure database for PostgresSql from Synapse Analytics
Hi, Is there a way to connect and query Azure Database for PostgresSql from Synapse Analytics.We need near real time data from postgres database to join the CosmosDB data in Synapse Analytics. I would really appreciate for the input. Thanks!
asked 2024-06-13T12:33:24.1+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(201.6, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sathya Sai Cheetirala
0
Reputation points
commented 2024-06-17T04:44:29.6133333+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, 48%, 11%)' 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)
Harishga
5,420
Reputation points Microsoft Vendor