After Postgresql flexible migration from version 11 to version 16 admin user cannot change ownership of database
Since the migration of the PostgreSQL Flexible version I am unable to ALTER ROLE and change database owner (ALTER DATABASE db OWNER TO new_role;) When running this command: ALTER DATABASE db1 OWNER TO new_role; I am getting the following error: ERROR:…
Azure Database for PostgreSQL flexible server stuck in restart
The server got stuck in restart and the question what to do now besides delete and recreate. Any other way to get to this server?
How to connect Azure Database for PostgreSQL azure_ai extension to Azure OpenAI instance with private endpoint
I'm following the guide on working with AI functions in Azure Database for PostgreSQL backed by Azure OpenAI. I'm working with an Azure OpenAI instance that has (only!) private endpoint deployed. Azure App Service is able to connect to the Azure OpenAI…
Planned Maintenance Notification: Temporary Downtime for Azure PostgreSQL Flexible Server on 23rd March 2025 (IST)
We have received a notification about a planned maintenance window for our Azure Database for PostgreSQL Flexible Server on 23rd March 2025 (IST). Could you please confirm if there is any risk of data loss during this maintenance? Additionally, should we…
We have a large number of IaaS PostgreSQL servers that we want to migrate to PostgreSQL Flexible Service
Hi We have a large number of IaaS PostgreSQL systems where they have been built on a 1:1 basis for each application. These instances run on Small VMs in Azure, and a generally very small, and have very low cpu and memory utilisation. All systems are…
How to fix 'Service and subscription limits' on PostgreSQL Fexible Server deployment using bicep file?
tags: ResourceDeploymentFailure, PostgreSQL Fexible Server deployment, bicep file, MS Learn tutorial, Git cloned .../mslearn-postgresql.git Exceptions support request with Issue type of 'Service and subscription limits'. I cannot file Exception Support…

how to upgrade PostgreSQL client in azure cloud shell
Hi, I have run the below command and getting below error. pg_dump -Fc -v --host=XXXXXXX --username=XXXXX --dbname=XXX -f test_dev_flexi_psqllogtim.dump Password: pg_dump: error: server version: 15.7; pg_dump version: 14.13 pg_dump: error: aborting…
Postgresql Flexble server on-demand backup
HI Microsoft, I was doing a test of the preview feature 'on-demand' backup for Azure PostreSQL flexing instance. When I clicked "Backup (Preview)" option under Settings ==> Backup it started the backup as expected but I noticed that the…
How can we connect on-prem java application to Azure Database for PostgreSQL - Flexible Server using access token( managed identity or entra id)
i have a Azure Database for PostgreSQL - Flexible Server. my azure webapp connects to database using system assigned managed identity. how can we connect one of my on prem java application to database using managed identity or entra id? How the…
Actual Backup Cost and Compression Ratio in Azure Database for PostgreSQL
The Azure Pricing Calculator provides an estimated backup cost per GB, but I would like to understand how I can determine the actual backup cost for my Azure PostgreSQL Flexible server. Additionally, I would like to know the backup compression ratio…
Unable to create Azure Database for Postgres Flexible Server using terraform script due to Internal Server Error.
Hello everyone, I'm unable to create an azurerm_postgresql_flexible_server resource using terrafrom script. I'm getting following error: user@host:~/infra$ terraform apply tfplan.terraform azurerm_postgresql_flexible_server.postgressrv:…
Cannot Drop Role with "Replication" Attribute in Azure PostgreSQL Flexible Server 16
Hello, I am encountering the following error when trying to drop a role that has the "REPLICATION" attribute enabled. ERROR: permission denied to drop role Detail: Only roles with the CREATEROLE attribute and the ADMIN option on role…


PG Flexi Server is showing in updating state from past 7 days.
I changed the configuration of my Postgres Flexible server from D4s to D2s and it is showing in updated state since then.
Cannot insert into timescaledb table after migration from Signle Server to Flexible Server
Hi, our Azure Database for PostgreSQL single server was automatically migrated to Database for Azure Database for PostgreSQL flexible server last Saturday. Since then we can no longer insert data into timescaledb tables. The following error appears on…
PostgreSQL can't be connected by Power Apps
I am trying to setup a connection on Power Apps to PostgreSQL flexible servers on Azure. The network uses public access and allows all IPs on the PostgreSQL firewall. I get an error related to credentials when setting up a PostgreSQL connection on Power…
Can't we reduce the postgres storage once upgraded ?
Hello , I have an postgres deployed on my azure env but from the past couple of months we have been facing storage issues hence we are trying to downgrade the storage as we fixed the code and but I don't see the option of previous storage like earlier…
Azure Database for PostgreSQL flexible server with Storage autogrow enabled, yet the server ran out of storage and became read-only.
I have an Azure Database for PostgreSQL flexible server with Storage autogrow enabled, yet the server ran out of storage and became read-only.
Maximum QPS for Azure PostgreSQL Flexible Server
Is there a dependency between the maximum queries per second that Azure PostgreSQL Flexible Server can support and the compute SKU of the flexible server?If not what are the factors affecting maximum queries per second that azure postgres flexible server…
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…
What are the differences between Elastic clusters on Azure Database for PostgreSQL flexible server and Azure Cosmos DB for PostgreSQL cluster
What are the differences between Elastic clusters on Azure Database for PostgreSQL flexible server and Azure Cosmos DB for PostgreSQL cluster