1,260 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

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
asked 2025-03-20T07:55:33.05+00:00
Ryszard Sikora 0 Reputation points
0 answers

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?

Azure Database for PostgreSQL
asked 2025-03-05T12:19:14.4366667+00:00
Francis Antonietti 10 Reputation points
commented 2025-03-20T05:25:25.5166667+00:00
ShaktiSingh-MSFT 16,266 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-20T05:20:26.7733333+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-20T04:51:09.87+00:00
Saraswathi Devadula 235 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
commented 2025-03-20T04:01:11.6866667+00:00
Adithya Prasad K 245 Reputation points Microsoft External Staff
0 answers

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…

Azure Database for PostgreSQL
asked 2025-01-07T13:57:32.81+00:00
József Orbán 35 Reputation points
commented 2025-03-20T03:46:49.83+00:00
Jack P 0 Reputation points
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
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
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 80 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