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…
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…
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.
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…
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
How to recover a deleted Azure Postgresql server in Azure US Government Cloud?
We accidentally deleted an Azure PostgreSQL Flexible Server that was still being used by one of our legacy services. I’ve already gone through the steps outlined in the official Microsoft documentation: "Restore a dropped Azure Database for…
Shut down Azure PostgreSQL without Azure restarting it automatically
I created an Azure PostgreSQL database and when I shut it down I don't want it to restart automatically, how to fix that? This is what I get every time I shut down the database:
Azure database for Postgres Flexible server - Why creating extension uuid-ossp requires azure_pg_admin role?
My question is with respect to Azure Database for Postgres Flexible server (version PG16). I tried to create extension on current database (logged into database as db owner) however I see an error stating "ERROR: Only members of…