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
When i upgrade my azure postgres flexi server version from 11 to 16 it is giving error as "internal server error".
When i upgrade my azure postgres flexi server version from 11 to 16 it is giving error as "internal server error".
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
Postgres version upgrade: Broken user/role management after upgrade to v16
Hello, I am having issues with my Postgres instance (Azure Flexible Server for Postgres). After the upgrade from V12 to V16 (more specifically, the issue stems from the upgrade to V16), we lost the ability to modify existing users and roles in our…
Azure Database for PostgreSQL
Unable to increase postgres flexible server plan
Hi, I’ve tried several times via the Azure Portal and to scale server erp-api-dev-postgres3 from B2ms (2 vCores, 4 GiB) to Standard_D4ds_v5 (4 vCores, 16 GiB, 6400 max IOPS). Each attempt sits in Updating for a few minutes and then flips to Failed with…
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
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
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…
Azure Database for PostgreSQL
Is there a way to entity resolution / entity deduplication at scale with PostgreSQL and PGvector?
I'm working on merging company data from several different providers. I'm exploring an entity resolution approach using separate embeddings for name, location, and domain, stored in vector indexes. I'm considering postges as a database option, however…
Azure Database for PostgreSQL
How to fix database server is disabled
Hai, may i know how to fix this issue. The server is currently in 'disabled' 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. this is a postgresql…
Azure Database for PostgreSQL
Azure PostgresSQL Flexible server missing in my resources
I've received an email saying that there will be a major upgrade in postgres flexible server by the end of November. I went to the portal to do the upgrade but my resource is simply gone. There's no way to find it to perform the upgrade. I'm sure I'm…
Azure Database for PostgreSQL
Azure pgSQL Server restart takes too long time
Our production pgSQL Server has been restarted because of a server parameter update (max connection has been increased). Deployment of parameter update was successfull and the automatic server restart has been started, which already takes an hour. Please…
Azure Database for PostgreSQL
Subscription 'Microsoft Azure Sponsorship' is not allowed to provision in 'East US'.
Pretty much as stated, I can't create a resource, Azure Database for PostgreSQL flexible server, within the East US region. I got no idea why. I've been able to create resources in East US for the past few weeks using terraform without issue. When I look…
Azure Database for PostgreSQL
Issue with PostgreSqlFlexibleServerBlade: Cannot Delete or Create Resource
Encountering an issue while creating a database from the CLI, where the server is stuck in a dropping state and cannot be deleted. When trying to create a resource with the same name, it indicates that it already exists. However, deleting the resource…
Azure Database for PostgreSQL

postgresql database after major version upgrade is not available
I have started a major version upgrade from pgSQL v14 to 16. In the first 2-3 hours the browser was open and the deployment was ongoing. After my notebook restart some hours later and re-enter the azure portal I cannot find the deployment activity…