Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
983 questions
0 answers
how to connect to CITUS remotely
I have using single node CITUS, my coordinator node running on 9700 and my PostgreSQL running on 5432 I don't know how I can remote connect my CITUS coordinate node
asked 2024-08-18T01:49:07.85+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
asked 2024-08-18T01:49:07.85+00:00
Naveen Kumar Kakarla (Quadrant Resource)
201
Reputation points
1 answer
Request for Subscription Cancellation and Refund
Dear Azure Support Team, I hope this message finds you well. I am writing to request the cancellation of my Azure subscription and a refund for the recent charge made to my account. Despite not intending to continue with the subscription, I noticed a…
asked 2024-08-17T06:26:34.45+00:00
Murad Abdullayev
0
Reputation points
answered 2024-08-17T11:11:25.33+00:00
Marcin Policht
19,725
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
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
Yichen Tian
20
Reputation points
commented 2024-08-16T14:48:14.4733333+00:00
Serpa
156
Reputation points
0 answers
how to improve the azure PostgreSQL flexible server performance in cloud
Hi Team, When we are calling our Api which has multiple database queries, it is allowing only 10 instances to connect with DB. From the 11th instance or connection, we are getting socket exception with error message socket closed. Can anyone help us how…
asked 2024-08-14T14:10:14.1+00:00
Kattekola Mahesh
5
Reputation points
commented 2024-08-16T06:54:28.7166667+00:00
Oury Ba-MSFT
18,191
Reputation points Microsoft Employee
2 answers
Error creating a Flexible Postgres Database in Azure
Getting this error when creating the database trough the Azure portal in south central US { "status": "Failed", "error": { "code": "InternalServerError", "message":…
asked 2024-07-30T18:32:19.02+00:00
Juan Ribon
0
Reputation points
commented 2024-08-15T17:10:16.54+00:00
Oury Ba-MSFT
18,191
Reputation points Microsoft Employee
1 answer
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB
Azure postgresql flex can i use local AD group synced to Azure AD for access to DB in Azure flex postgres
asked 2024-07-05T19:58:41.36+00:00
Mohammed, Shafi
0
Reputation points
commented 2024-08-15T16:36:39.3966667+00:00
Oury Ba-MSFT
18,191
Reputation points Microsoft Employee
0 answers
How can fix LongTermRetentionBackupInternalError
I am trying to make a backup to Azure database Postgres SQL flexible server but it fails and gives me this error LongTermRetentionBackupInternalError I followed https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex but…
asked 2024-08-13T06:40:28.3766667+00:00
Youssef Yassa
10
Reputation points
commented 2024-08-15T08:07:53.7233333+00:00
Anderson Leite
0
Reputation points
0 answers
Is the Azure Database for PostgreSQL single server dropped after its migrated to flexible server?
I want to migrate my Azure Database for PostgreSQL single server to flexible server. I was wondering what will happen to the single server database after it is migrated to flexible server? Basically the question is two-fold where I would like to…
asked 2024-08-14T02:50:34.5966667+00:00
Ravi Prabhat Dubey
0
Reputation points
commented 2024-08-15T07:51:50.2133333+00:00
Ravi Prabhat Dubey
0
Reputation points
1 answer
Cannot run a major upgrade on Azure Postgres Flexible Server with pgBouncer
Hi, I am trying to perform a major upgrade on my Azure Database for PostgreSQL flexible server from version 14 to version 16. However I am getting an internal server error from the upgrade process, with no detailed information about the exact cause apart…
asked 2024-08-10T08:28:06.69+00:00
Théo Mouchabac
0
Reputation points
commented 2024-08-14T15:52:19.8733333+00:00
Théo Mouchabac
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Can I change to owner of a database in Azure Database for PostgreSQL flexible server?
I have a database created with the migration tool in the Azure Database for PostgreSQL flexible server. The migration tool sets the database owner as the server admin, and I want to change the owner to a different role. How do I do this? ALTER DATABASE…
asked 2024-06-12T19:41:39.73+00:00
Kristine Kisman
25
Reputation points
commented 2024-08-14T14:08:30.9733333+00:00
Oury Ba-MSFT
18,191
Reputation points Microsoft Employee
0 answers
Why private endpoint does not connect
Hello, We setup the private endpoint to connect ADF to flexible server postgres server. The endpoint is setup and approved on postgres side, but the pipeline cannot connect. Can you confirm if this is the reason:…
asked 2024-08-09T11:35:07.9+00:00
Wang, Yue
0
Reputation points
commented 2024-08-13T16:09:56.2766667+00:00
Bhargava-MSFT
29,716
Reputation points Microsoft Employee
1 answer
How to buy Reservation for Postgresql flexible servers HA instance
I can't seem to find any official documentation on precisely how to buy Azure PostgreSQL's flexible server instance's High Availability instance (Secondary instance). I am aware buying the Reservation will apply for the primary instance. Does anyone have…
asked 2024-08-02T02:03:17.58+00:00
Lippy
65
Reputation points
answered 2024-08-13T03:58:10.1666667+00:00
ShaktiSingh-MSFT
14,701
Reputation points
1 answer
Setup replica in Azure PostgreSQL flexible server without VNET Peering
Hi, Is it possible to setup an Azure PostgreSQL flexible server with its replica located in a different region without VNET peering. Regards TM
asked 2024-08-05T12:48:57.5566667+00:00
Mulla, Tabrez
20
Reputation points
commented 2024-08-12T14:54:52.06+00:00
GeethaThatipatri-MSFT
29,102
Reputation points Microsoft Employee
1 answer
Will Postgres flexible server upgrade support new features
Hi, We have to install private endpoint to connect from ADF to Postgres flexible server. The question is the server was created in 2023 and the support for private endpoint for it only exists since Feb 2024. I wonder if an upgrade of the server will get…
asked 2024-08-08T14:50:49.52+00:00
Wang, Yue
0
Reputation points
commented 2024-08-12T13:31:56.28+00:00
GeethaThatipatri-MSFT
29,102
Reputation points Microsoft Employee
0 answers
Permissions and roles for Backup Vault Restore of a postgreSQL flexible server
I am currently trying to use the Azure Backup Vault for our PostgreSQL flexible servers. I have followed this tutorial https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex-overview and provided the required permissions to…
asked 2024-08-02T09:57:03.0966667+00:00
Öksüz, Enes
0
Reputation points
commented 2024-08-09T20:36:57.27+00:00
SadiqhAhmed-MSFT
42,776
Reputation points Microsoft Employee
1 answer
Azure PostgreSQL Flexible Server Logs, auto_explain.format escape characters
Hi, When attempting to read auto_explain plans out of either the Az PostgreSQL server logs (where you can download them) or out of something like LogAnalytics, the explain plan is messed up. Take for example, something like this. There is no easy way…
asked 2024-08-02T17:54:43.41+00:00
Eric Singer
0
Reputation points
answered 2024-08-09T19:09:00.94+00:00
Eric Singer
0
Reputation points
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
Pitawat
341
Reputation points
commented 2024-08-09T07:14:01.7433333+00:00
Hána František
0
Reputation points
0 answers
How to fix 403 in app service with postgres flexible server?
We have an existing app service and are migrating the data and application from mongodb to a flexible postgres-server database. The stack consists of 3 private endpoints with network interfaces, for the frontend, the keyvault and the postgres-db.…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,146 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
983 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,526 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,919 questions
asked 2024-08-08T13:41:04.69+00:00
Anita Veldman
0
Reputation points
edited the question 2024-08-08T13:44:56.9466667+00:00
Anita Veldman
0
Reputation points
1 answer
PostgreSQL Flexible server availability issue
I want to create Azure Database for PostgreSQL Flexible server with High availability Zone redundant (99.99 SLA) but this option is unable to be selected it, only available Disabled (99.9% SLA) and Same zone (99.95% SLA) east us region @Anonymous can…
asked 2024-08-08T00:27:35.79+00:00
Youssef Yassa
10
Reputation points
answered 2024-08-08T10:00:39.77+00:00
ShaktiSingh-MSFT
14,701
Reputation points
1 answer
One of the answers was accepted by the question author.
What is "storage account" during postgresql flexible server restoration process?
Hello, I know that probably I am missing something, but cannot figure out what I am doing wrong. I created a backup for my Postgresql flexible server exactly as described…
asked 2024-08-01T14:11:16.1833333+00:00
Mateusz Klimas
20
Reputation points
commented 2024-08-08T09:28:25.4033333+00:00
Mateusz Klimas
20
Reputation points