Azure Database for PostgreSQL flexible server stuck in stopping state - need assistance recovering
The Azure Database for PostgreSQL flexible server in our production environment has been down for over 20 hours. No connection can be made, whether through the Azure Portal, via pgAdmin4, or through the application. There was a critical health event…
Azure Database for PostgreSQL
PostgrSQL Flexible server stacked in Dropping state
Hello Azure Support Team and Community, I am an Azure Free Tier user experiencing a critical issue with an Azure PostgreSQL Flexible Server instance that is stuck in a 'Failed' provisioning state, preventing its deletion and the deletion of its…
Azure Database for PostgreSQL
Workloads failing on Azure Postgres flexible server.
Workloads that are newly started on our database are failing with the error: "ERROR: Only members of "azure_pg_admin" are allowed to use CREATE EXTENSION [Failed SQL: (0) CREATE EXTENSION IF NOT EXISTS "uuid-ossp"". This was…
Azure Database for PostgreSQL
PostgreSQL flexible server resource destroying trouble.
I was destroying infrastructure with terraform and it take to much time to destroy postgres db so i interrupted destroying process and did it manually via portal
Azure Database for PostgreSQL
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…
Azure Database for PostgreSQL
Postgres server went down due to 'platform issue', attempted point in time restore but it's still going an hour later!?
My postgres server went down for unknown 'platform' reasons, nothing I did on my end. I tried a point in time restore to about an hour before it went down and it has been in the 'Running' state under 'Provsioniong' for an hour now. How to fix and restore…
Azure Database for PostgreSQL
How to revive dropped Azure PostgreSQL flexible server with databases and data?
Testing some backup/recovery scenarios for my deployment. One of them would be accidentally destroying an environment via terraform destroy, including a flexible server for PostgreSQL with relevant data running in there. Now, according to Azure's…
Azure Database for PostgreSQL
"High Availability and Failover Configuration in PostgreSQL Flexible Server"
How can I configure automatic failover and high availability in Azure Database for PostgreSQL Flexible Server, and what are the recovery time objectives (RTO) in case of a zone failure?"
Azure Database for PostgreSQL
Query completes on Azure PostgreSQL but client keeps running (state = idle in transaction / ClientRead)
Environment Service: Azure Database for PostgreSQL – Flexible Server (General Purpose, D2ds_v5, 2 vCores, 8 GiB RAM, 1024 GiB storage) Client OS: Windows 11 / WSL 2 PostgreSQL version: 15.12 Problem I connect from PyCharm and run fairly simple DDL /…
Azure Database for PostgreSQL
I am trying to scale Azure Postgresql Flexible Server, but it just rolling in Started stage and nothing is happening. What could cause this? Server is working fine but we need more cores to keep up with demand, but currently unable to scale up.
I am trying to scale Azure Postgresql Flexible Server, but it just rolling in Started stage and nothing is happening. What could cause this? Server is working fine but we need more cores to keep up with demand, but currently unable to scale up. I have…
Azure Database for PostgreSQL
Java non-admin ad user can't login--Azure AD user token for role[******@xxxxx.onmicrosoft.com] does not match auth_oid.
Hi: Following the quick start guide, Quickstart: Use Java and JDBC with Azure Database for PostgreSQL flexible server, in the link below I was able to use psql to login to PostgreSQL using the AD admin & non-admin users (after login via az login…
Azure Database for PostgreSQL
Why is storage usage increasing consistently and overloading our Azure Postgresql server?
Storage usage has been consistently increasing in our Postgresql server since May 28th until yesterday, when it got overloaded. The effective size of the database is around 20GB, while the database storage used has reached 120+ GB. Why is it happening? …
Azure Database for PostgreSQL
Azure PostgreSQL Flexible Server stuck in "DROPPING" state
Hello, A couple of resource groups with a VNet and Azure PostgreSQL Flexible Server were deployed yesterday. Due to misconfigurations, a decision was made to remove the entire resource groups, including the resources. Unfortunately, Azure is unable to…
Azure Database for PostgreSQL
How to add metadata for every record in Azure postgres tables
Hi, I have a situation in one of the applications I am working on where prior to going live in production, we are going to migrate data from legacy systems over the period of few weeks. And at the same time, there will be activity from users in this…
Azure Database for PostgreSQL
We need to encrypt postgres instance with a customer CMK from another tenant.
We have a use case where we need to encrypt data at rest for a postgres instance inside our tenant but using a customer CMK. The customer is hosted in an external microsoft tenant - is this possible? According to doc re:…
Azure Database for PostgreSQL
I want to Migrate database resources from one subscription to another subscription with in Azure
We have a Postgres flexi database provisioned in unmamaged subscription in Azure and now we want to migrate to a managed subscription, so want to understand what is the best possible approach.
Azure Database for PostgreSQL
Create extension in Azure PostgreSQL
It seems that there is a bug in the Azure document. According to this link (https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions), it said that the user that creates the extension must be a member of the azure_pg_admin…
Azure Database for PostgreSQL
How do I request region enablement for PostgreSQL Flexible Server in Germany West Central?
How do I request region enablement for PostgreSQL Flexible Server in Germany West Central??
Azure Database for PostgreSQL
Facing issue while migrating azure postgres flexi server to GCP
We are currently migrating data from an Azure Database for PostgreSQL – Flexible Server instance to Google Cloud PostgreSQL using Google’s Database Migration Service (DMS). A HA VPN tunnel has been successfully established between Azure and GCP, with BGP…
Azure Database for PostgreSQL
How to achieve blue/green upgrades in Azure Database for PostgreSQL flexible server
Hi Greetings, I was looking at options that can help us achieve a blue/green upgrades pattern for updating compute configs for our Azure Database for PostgreSQL flexible server, I had explored read replica promotion to primary and promotion to…