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
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…
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…
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…
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":…
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
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…
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…
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…
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…
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:…
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…
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
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…
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…
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…
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…
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.…
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…
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…