1,540 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

Azure postgre sql mirroring does not install cdc extension in one of the db

Mirroring on the postgresql db does not install cdc extension which does not allow mirroring to be enabled in default db named postgres it isntalls but in our other db it does not. Anyone have an idea why it can be like this ? We using the preview…

Azure Database for PostgreSQL
asked 2025-08-25T10:48:25.8733333+00:00
Gediminas 20 Reputation points
edited a comment 2025-08-29T14:58:27.65+00:00
Swapnesh Panchal 5 Reputation points Microsoft External Staff Moderator
0 answers

Database Stuck in 'Starting' Status on Azure PostgreSQL Flexible Server

The Azure Database for PostgreSQL flexible server in the East US region is currently stuck in the Starting state. Attempts to restart it using the Azure CLI have been unsuccessful. No recent changes were made to the database, and restoring is not…

Azure Database for PostgreSQL
asked 2025-08-29T14:19:51.3833333+00:00
Bruno Godoi 0 Reputation points
commented 2025-08-29T14:40:05.9633333+00:00
Saraswathi Devadula 12,675 Reputation points Microsoft External Staff Moderator
0 answers

Serious bug in Azure Database for PostgreSQL Flexible Server PostGIS extension

The Azure Database for PostgreSQL Flexible Server instances that we have were upgraded over the weekend (on Saturday 16th, as far as I can tell). The upgrade has introduced a new version of the PostGIS extension that we rely on. You can see from this…

Azure Database for PostgreSQL
asked 2025-08-21T16:03:55.86+00:00
Martin Daly 0 Reputation points
edited a comment 2025-08-29T14:35:22.1966667+00:00
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Zone Redundancy not available in East US2

We have our new subscription that we created in Aug 2025, and we have our previous subscription that was created before August 2025 which contains Azure Database for PostgreSQL instances with Zone redundancy and High Availability. Currently, on our…

Azure Database for PostgreSQL
asked 2025-08-21T11:51:05.82+00:00
Nxtstim 20 Reputation points
edited an answer 2025-08-29T11:00:27.76+00:00
JananiRamesh-MSFT 29,281 Reputation points Moderator
1 answer

pgvector 0.8.0 + hnsw on azure postgresql flexible server stopped working

Description: We are seeing queries fail in production after upgrading to pgvector 0.8.0 Query example: WHERE (t."Embedding" <=> $1) < 0.6 ORDER BY t.c Error output: server process (PID 3853) was terminated by signal 4: Illegal…

Azure Database for PostgreSQL
asked 2025-08-21T12:42:45.84+00:00
Sami Chkhachkhi 0 Reputation points
commented 2025-08-29T10:40:33.54+00:00
Sami Chkhachkhi 0 Reputation points
0 answers

pg_trgm Extension Not Allowed on Azure Database for PostgreSQL Flexible Server – Alternatives and Cloud Comparison

Dear Microsoft Community, We are currently exploring advanced search functionality for our application hosted on Azure Database for PostgreSQL (Flexible Server). Our use case involves fuzzy text search on a product catalog, specifically using a string…

Azure Database for PostgreSQL
asked 2025-08-28T10:05:16.4733333+00:00
Rishav Arora 25 Reputation points
edited a comment 2025-08-29T10:19:35.0833333+00:00
Saraswathi Devadula 12,675 Reputation points Microsoft External Staff Moderator
2 answers

Cannot add azure_ai or azure storage extension to Flexible PostgreSQL 16.9

When I run the following SQL command: CREATE EXTENSION IF NOT EXISTS azure_ai; --output from query: --Started executing query at Line 3 --permission denied to alter restricted role "azure_pg_admin" CREATE EXTENSION IF NOT EXISTS…

Azure Database for PostgreSQL
asked 2025-08-28T09:31:06.01+00:00
Espen Sandtveit (Webstep AS) 0 Reputation points
commented 2025-08-29T09:17:26.12+00:00
Espen Sandtveit (Webstep AS) 0 Reputation points
0 answers

Cannot create new Role with postgres Flexible server

On one of our Postgres Flexible server we cannot create new role anymore. The server is on 16.9 and when trying to create a new role when connected with the admin account we get this error: postgres> CREATE ROLE "new_test_role"; permission…

Azure Database for PostgreSQL
asked 2025-08-26T19:37:00.77+00:00
Jérôme Villeneuve-Larouche 10 Reputation points
commented 2025-08-29T09:02:45.2633333+00:00
Kalyani Kondavaradala 1,015 Reputation points Microsoft External Staff Moderator
0 answers

Upgrade PostgreSQL flexible server from 16.8 to 17 with PostGIS installed

Hello! We are running a PostgreSQL flexible server version 16.8 with the PostGIS extension enabled. When we attempt to upgrade the flexible server to 17 we are stopped with an error indicating that the installed PostGIS version not being supported on…

Azure Database for PostgreSQL
asked 2025-08-19T14:41:00.78+00:00
Staffan Hedström - HMS 120 Reputation points
commented 2025-08-29T05:31:12.84+00:00
Saraswathi Devadula 12,675 Reputation points Microsoft External Staff Moderator
1 answer

Postgres flexible server stuck in starting

I have a flexible PostgreSQL server that is stuck in starting mode right now, and I can't do anything with it. I tried to stop, restore, delete it without any success, is there any way to force it to stop? (SeverBusyWithOtherOperation) Cannot perform…

Azure Database for PostgreSQL
asked 2025-08-28T23:02:11.0633333+00:00
WindersonSouza-2279 0 Reputation points
answered 2025-08-29T01:42:34.58+00:00
Suwarna S Kale 3,956 Reputation points
0 answers

Azure PostgreSQL Flexible Server Unavailable - Restart Failures and Connection Issues

As of Tue Aug 26 2025 10:38:59 GMT-0400 we've been experiencing critical issues with our Azure PostgreSQL Flexible Server (Region: Central US). Our server is running Postgres Version 15.13. Issue Details: Service Unavailability: The server is currently…

Azure Database for PostgreSQL
asked 2025-08-26T19:24:55.25+00:00
Fitzgerald Callender 0 Reputation points
commented 2025-08-29T00:13:21.2433333+00:00
Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator
0 answers

PostgreSQL database down after a maintenance window

Database is down during maintenace window schedule, and is unavailable.

Azure Database for PostgreSQL
asked 2025-08-21T07:58:02.2433333+00:00
Rafa Lachica Garrido 20 Reputation points
commented 2025-08-28T15:48:26.7033333+00:00
Abhisek Mishra 85 Reputation points Microsoft External Staff Moderator
0 answers

Cannot add azure_storage extension to Flexible PostgreSQL 15.13

I was working on the Azure Storage extension in Azure Database for PostgreSQL flexible server. I followed the steps described here: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/quickstart-azure-storage-extension but got the…

Azure Database for PostgreSQL
asked 2025-08-26T16:57:27.4333333+00:00
Talha Nasr 25 Reputation points
commented 2025-08-28T12:24:03.1066667+00:00
Kalyani Kondavaradala 1,015 Reputation points Microsoft External Staff Moderator
0 answers

Postgres Flexible Server stuck at start

Hello, I have a similar problem as https://learn.microsoft.com/en-us/answers/questions/5523543/the-postgresql-server-is-stuck-in-updating-state-f: Yesterday, I tried to upgrade the PostgreSQL version of my Server for which I waited more than 4 hours…

Azure Database for PostgreSQL
asked 2025-08-28T08:41:01.0733333+00:00
Emanuel 0 Reputation points
commented 2025-08-28T12:00:39.8533333+00:00
Kalyani Kondavaradala 1,015 Reputation points Microsoft External Staff Moderator
1 answer

CosmosDB for postgresql stuck in Provisioning state

I am planning to use Read Replicas for my Cosmos DB for postgresql. I started with creating a replica of my existing DB instance on East US region. The status shows as created on Deployment page, but the DB instance shows provisioning state and it is not…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,948 questions
Azure Database for PostgreSQL
asked 2023-09-28T17:13:19.2133333+00:00
Vipal Mehta 45 Reputation points
answered 2025-08-28T07:34:01.4333333+00:00
A, Kowsalya (Cognizant) 20 Reputation points
0 answers

PostgreSQL Felxible Server Logs missing

Hello, We have an Azure Database for PostgreSQL flexible server, and i turned on all the diagnostics settings, sending them to a Log Analytics workspace. I modified only a few key Log parameters of the PostgreSQL server Seemingly out of nowhere, On…

Azure Database for PostgreSQL
asked 2025-04-22T00:50:11.3+00:00
Vin Centso 0 Reputation points
commented 2025-08-28T01:27:25.2033333+00:00
Jason Weathered 0 Reputation points
1 answer One of the answers was accepted by the question author.

What is the downtime for a PostgresSQL major upgrade from version 13 to version 17

Looking to upgrade Azure PostgresSQL and need to find out the downtimes so i can put through a change request for the client.

Azure Database for PostgreSQL
asked 2025-08-27T09:19:27.2866667+00:00
Kay Adegbiji 20 Reputation points
accepted 2025-08-27T14:51:46.1933333+00:00
Kay Adegbiji 20 Reputation points
1 answer

How to create a PL/pgSQL function in a database using a bash script?

I have tried to install two PL/pgSQL functions, run the second of them, save the output of the function in a variable, export it to an SQL file and run the exported file, using a bash script: #!/bin/bash # function to install pg functions into the…

Azure Database for PostgreSQL
asked 2025-08-25T13:02:09.84+00:00
Diogo dos Santos 30 Reputation points
answered 2025-08-27T13:36:06.5333333+00:00
Kalyani Kondavaradala 1,015 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure Database For PostgreSQL flexible Server - Internal Server Error when trying to update server parameters

When I try to redeploy the server parameters in Azure Database for PostgreSQL flexible server after specifying a vector, I get an Internal Server Error every time. There's no other explanation in the details section, so I can't understand the reason. How…

Azure Database for PostgreSQL
asked 2025-08-26T04:53:30.26+00:00
Sefa 20 Reputation points
commented 2025-08-26T17:55:17.0666667+00:00
Sefa 20 Reputation points
1 answer

Cannot add azure_storage extension to Flexible Postgres 16.9

When I run the following SQL command: CREATE`` ``EXTENSION`` ``IF`` ``NOT`` ``EXISTS`` azure_storage; I get the following error: ERROR: permission denied to alter restricted role "azure_pg_admin" I can confirm that the extension has been…

Azure Database for PostgreSQL
asked 2025-08-11T10:05:36.7466667+00:00
Conor Nash 15 Reputation points
commented 2025-08-26T16:58:27.6133333+00:00
Talha Nasr 25 Reputation points