1,259 questions with Azure Database for PostgreSQL tags

Sort by: Updated
3 answers

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…

Azure Database for PostgreSQL
asked 2025-01-22T09:55:35.3366667+00:00
S, P1686MS (623-WIPRO LIMITED) 0 Reputation points
commented 2025-03-19T17:05:27.6466667+00:00
Roberto Roldán 0 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 2025-03-17T15:12:23.3166667+00:00
Joep Sterk 0 Reputation points
commented 2025-03-19T12:05:28.97+00:00
PratikLad 320 Reputation points Microsoft External Staff
0 answers

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…

Azure Database for PostgreSQL
asked 2025-03-19T09:05:26.6266667+00:00
Sudhakar P 105 Reputation points
commented 2025-03-19T09:53:55.5233333+00:00
Saraswathi Devadula 235 Reputation points Microsoft External Staff
4 answers

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…

Azure Database for PostgreSQL
asked 2025-03-16T23:04:37.28+00:00
subhash-DBA 110 Reputation points
answered 2025-03-19T09:23:16.98+00:00
PratikLad 320 Reputation points Microsoft External Staff
1 answer

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…

Azure Database for PostgreSQL
asked 2025-03-12T11:38:21.4933333+00:00
Kanhaiya Sharma 20 Reputation points
commented 2025-03-19T09:19:47.0433333+00:00
Kanhaiya Sharma 20 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 2025-03-12T11:21:06.57+00:00
Azeem, Muhammad 10 Reputation points
commented 2025-03-19T08:13:19.2633333+00:00
Adithya Prasad K 245 Reputation points Microsoft External Staff
1 answer

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

Azure Database for PostgreSQL
asked 2025-03-07T08:50:48.3566667+00:00
Shubham Kumar (iDEAS-Group) 0 Reputation points
commented 2025-03-19T05:10:30.6766667+00:00
Shubham Kumar (iDEAS-Group) 0 Reputation points
0 answers

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…

Azure Database for PostgreSQL
asked 2025-03-06T19:29:17.0533333+00:00
Gabriel Aquino 0 Reputation points
commented 2025-03-18T18:04:00.62+00:00
Gabriel Aquino 0 Reputation points
0 answers

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.

Azure Database for PostgreSQL
asked 2025-03-13T15:22:21.78+00:00
Harsh Mittal 0 Reputation points
commented 2025-03-18T17:43:12.5633333+00:00
Mahesh Kurva 3,335 Reputation points Microsoft External Staff
1 answer

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…

Azure Database for PostgreSQL
asked 2025-03-18T13:19:32.1833333+00:00
MATTHEWS Timothy 0 Reputation points
answered 2025-03-18T14:54:44.1666667+00:00
Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff
2 answers One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2025-03-17T13:52:42.17+00:00
Vladimir Shurakov 61 Reputation points
accepted 2025-03-18T07:16:53.6066667+00:00
Vladimir Shurakov 61 Reputation points
1 answer One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2025-03-13T03:18:03.73+00:00
Irvanda 136 Reputation points
accepted 2025-03-18T01:31:29.3633333+00:00
Irvanda 136 Reputation points
2 answers

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
asked 2025-03-12T06:07:46.48+00:00
ReCloudS 60 Reputation points
answered 2025-03-18T00:48:27.91+00:00
Mallaiah Sangi 345 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

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.

Azure Database for PostgreSQL
asked 2025-03-13T15:55:33.4966667+00:00
Cosmin Robert Lungu 20 Reputation points
accepted 2025-03-17T20:42:44.26+00:00
Cosmin Robert Lungu 20 Reputation points
2 answers

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…

Azure Database for PostgreSQL
asked 2025-03-11T22:08:47.8066667+00:00
Sai 0 Reputation points
commented 2025-03-17T17:30:14.76+00:00
Prasad Chaganti 85 Reputation points Microsoft External Staff
1 answer

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
asked 2025-03-06T15:11:45.9566667+00:00
Sarah Langheinrich 5 Reputation points
commented 2025-03-17T08:41:35.0266667+00:00
PratikLad 320 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

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

Azure Database for PostgreSQL
asked 2025-03-16T06:26:47.8966667+00:00
Naveen Kumar Kakarla (Quadrant Resource LLC) 20 Reputation points Microsoft External Staff
accepted 2025-03-16T15:16:28.8066667+00:00
Naveen Kumar Kakarla (Quadrant Resource LLC) 20 Reputation points Microsoft External Staff
0 answers

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…

Azure Database for PostgreSQL
asked 2025-03-13T11:04:16.58+00:00
Sachin Vettiyattil 21 Reputation points
commented 2025-03-14T04:27:31.36+00:00
Sachin Vettiyattil 21 Reputation points
1 answer

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 PostgreSQL
asked 2025-03-10T21:58:24.8033333+00:00
Pablo Schor 0 Reputation points
commented 2025-03-13T21:17:50.82+00:00
Prasad Chaganti 85 Reputation points Microsoft External Staff
3 answers One of the answers was accepted by the question author.

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…

Azure Database for PostgreSQL
asked 2024-10-30T10:51:45.6933333+00:00
Tulsiraja Shastry 20 Reputation points
edited a comment 2025-03-13T19:05:25.36+00:00
Bernd E 0 Reputation points