1,427 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

Due to maintenance task being performed on your Azure Database for PostgreSQL - Flexible server, the server is temporarily unavailable.

Hi, The maintenance period ended and my sever never came alive after. Thankfully Azure provides little to no useful documentation as to the nature of the failure and is now continuously just attempting to restart - obviously failing each time. Please…

Azure Database for PostgreSQL
asked 2025-05-21T13:16:23.4866667+00:00
Hunter (FIntivio) 0 Reputation points
commented 2025-05-21T13:44:04.27+00:00
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator
1 answer

PostgreSQL Single Server migration in flexible server.

Team, Currently, we are using Azure PostgreSQL Single Server, but as its support has ended, we are required to migrate to Azure PostgreSQL Flexible Server. We have received a notification that the default migration is scheduled for March 16. Since this…

Azure Database for PostgreSQL
asked 2025-02-26T06:20:06.45+00:00
Tripesh Dhoriya 0 Reputation points
commented 2025-05-21T10:03:29.3466667+00:00
Mariusz Ferdyn 5 Reputation points
1 answer

Zonal Redundancy Greyed out for SQL MI

Hello All, I am trying to create SQL MI. I wanted to enable the option for Zonal Redundancy, however, it is greyed out, Service Tier used- General Purpose HW Generation used- Premium-series - memory optimized - Intel Ice Lake, 13,6 GB RAM/vCore, up…

Azure Database for PostgreSQL
asked 2025-05-15T14:59:34.4+00:00
Gautam Limboo 25 Reputation points
commented 2025-05-21T07:59:50.6066667+00:00
PratikLad 1,825 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

PostgreSQL Flexible Server stuck in "Stopping" state – cannot restart or connect

I am experiencing an issue with my Azure PostgreSQL Flexible Server The server has been stuck in the Stopping state for an extended period (more than several hours) and is unresponsive. The server is unreachable, and I cannot connect via psql or through…

Azure Database for PostgreSQL
asked 2025-05-19T11:03:35.25+00:00
Mostafiz 20 Reputation points
accepted 2025-05-20T09:13:34.0166667+00:00
Mostafiz 20 Reputation points
2 answers

How to delete PG user when they have no ADMIN OWNER

I have a Azure Flexible Postgres Server and I have a user I want to delete. However I am not the superuser because that is Azure itself. I am a member of the azure_pg_admin group. But for some unknow reason the user has no ADMIN OWNER How could I…

Azure Database for PostgreSQL
asked 2025-03-27T12:02:48.1233333+00:00
Brenwell 0 Reputation points
answered 2025-05-19T14:31:12.64+00:00
Brenwell 0 Reputation points
1 answer One of the answers was accepted by the question author.

RTO for a non-HA PostgreSQL flexible server

For a non-HA PostgreSQL flexible server, in case of an "unplanned downtime" (for instance: hardware failure), what is the RTO depending on? Database size or something else? Is the automatically provisioned new database going to be restored…

Azure Database for PostgreSQL
asked 2025-05-14T13:12:05.87+00:00
Smania 20 Reputation points
accepted 2025-05-19T14:15:48.9566667+00:00
Smania 20 Reputation points
1 answer

Connection to Azure Data Studio and Heroku just failed.

Cannot connect to Azure Data Studio or Heroku anymore. I changed nothing and it just happened out of no where. I can connect to the server just fine in the Azure home page. Failed connections due to invalid authorization specification.

Azure Database for PostgreSQL
asked 2025-05-09T16:21:43.2533333+00:00
ckcDevelopment Admin 0 Reputation points
edited an answer 2025-05-19T11:57:08.85+00:00
Mihir Saxena 0 Reputation points Microsoft External Staff Moderator
1 answer

database queries are showing more active response time when hitting postgres flesxible database from vmss application using hikar pool

I am running application testing through vmss. azure pipelines are executing database statements through azure pipelines. when it is hitting postgres flesxible database there is a more response time. it shows active waiting on dynatrace side. can I get…

Azure Database for PostgreSQL
asked 2025-05-15T10:50:05.35+00:00
Kumar, Chandan 0 Reputation points
commented 2025-05-19T08:53:51.38+00:00
Vijayalaxmi Kattimani 3,250 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure scheduled auto migration from postgresql single server to flexible server is stuck 'in progress' status for 11 Days.

Hello, Azure had scheduled auto migration from Postgresql single server to flexible server. It has been stuck 'In Progress' status for last 11Days. I have no idea what is going on in the background nor I can check the progress. I have the following…

Azure Database for PostgreSQL
asked 2025-04-03T04:46:51.1866667+00:00
Rajuvardhana K V 60 Reputation points
commented 2025-05-19T05:11:38.8666667+00:00
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Azure Database for PostgreSQL flexible server stuck in stopping state - need assistance recovering

The Azure Database for PostgreSQL flexible server in one of our environments has been down for over an hour. No connection can be made, whether through the Azure Portal, via pgAdmin4, or through the application. There was a critical health event when…

Azure Database for PostgreSQL
asked 2025-05-19T01:09:41.8066667+00:00
Lachlan 30 Reputation points
commented 2025-05-19T04:06:53.27+00:00
Lachlan 30 Reputation points
1 answer One of the answers was accepted by the question author.

My Azure Database for PostgreSQL flexible server is running very slow and I need to understand why and/or how this can be enhanced

My Azure Database for PostgreSQL flexible server is running very slow and I need to understand why and/or how this can be enhanced

Azure Database for PostgreSQL
asked 2025-05-13T18:53:15.1233333+00:00
Craig Hardy 20 Reputation points
commented 2025-05-16T18:55:01.23+00:00
Craig Hardy 20 Reputation points
2 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 25 Reputation points
commented 2025-05-16T09:50:58.7333333+00:00
Bernd E 0 Reputation points
1 answer One of the answers was accepted by the question author.

Auto migration of Azure Database for PostgreSQL Single server did not happen

Hello Team, I’m currently managing two Azure Database for PostgreSQL – Single Server instances located in two different subscriptions. Despite nominating both for auto-migration to Flexible Server multiple times, the migration has not yet been…

Azure Database for PostgreSQL
asked 2025-05-14T05:31:16.7366667+00:00
Rajuvardhana K V 60 Reputation points
accepted 2025-05-16T07:43:07.25+00:00
Rajuvardhana K V 60 Reputation points
1 answer

Getting MultiAzHaIsOfferRestricted when trying to create a flexible postgresql server in eastus

Using Terraform, trying to create a postgres flexible server with the ZoneRedundant in a azurerm_postgres_flexible_server block: resource "azurerm_postgresql_flexible_server" "ai_db" { name =…

Azure Database for PostgreSQL
asked 2025-05-13T22:56:58.9+00:00
Meredith 0 Reputation points
answered 2025-05-16T07:23:26.6833333+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer

Unable to Connect to DB After Planned Maintenance

I am unable to connect to my Azure Database for PostgreSQL after scheduled maintenance. I'm still trying to troubleshoot exactly what the issue is.

Azure Database for PostgreSQL
asked 2025-05-14T16:31:26.3133333+00:00
George Miller 0 Reputation points
answered 2025-05-16T05:28:25.97+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer

PostgreSQL server is in disable state and cannot be restarted. Unable to restart Azure PostgreSQL server due to service being temporarily busy

Unable to restart the Azure PostgreSQL server. Error message: "An error occurred restarting the Microsoft.DBForPostgreSQL server. Error occurred restarting the server. Service is temporarily busy and the operation cannot be performed. Please try…

Azure Database for PostgreSQL
asked 2025-05-12T15:07:02.7633333+00:00
Kevin-0912 0 Reputation points
answered 2025-05-16T04:17:18.5666667+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure PostgresSQL Single Server Has Disappeared

Hi, Azure PostgreSQL Single Server has disapeared. It is not found in flexible server.

Azure Database for PostgreSQL
asked 2025-05-05T16:20:18.5733333+00:00
Frederic Aube 20 Reputation points
accepted 2025-05-15T22:31:35.7666667+00:00
Frederic Aube 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure PostgreSQL server unavailable

Our server is unavailable and we have no way of bringing it back online. How to fix it?

Azure Database for PostgreSQL
asked 2025-05-12T12:42:38.1166667+00:00
Thomas Oude Wesselink 20 Reputation points
accepted 2025-05-14T18:37:28.43+00:00
Thomas Oude Wesselink 20 Reputation points
1 answer One of the answers was accepted by the question author.

How to grant predefined roles in Azure Cosmos DB for PostgreSQL to a new user

I would like to create a read and write user in a Azure Cosmos DB for PostgreSQL for my application to login under. When trying to grant pg_read_all_data and pg_write_all_data to the role, I get an error because the default citus user is not an admin of…

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,901 questions
Azure Database for PostgreSQL
asked 2023-10-25T19:03:29.87+00:00
Andrew Shimon 20 Reputation points
edited an answer 2025-05-14T15:26:18.5+00:00
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
0 answers

The server is currently in 'updating' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long.

Azure Support is No where to be found. The server is currently in 'updating' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long. This was attempted last…

Azure Database for PostgreSQL
asked 2025-05-14T08:46:43.5733333+00:00
Nishal Singh 0 Reputation points
commented 2025-05-14T09:16:14.4366667+00:00
Vijayalaxmi Kattimani 3,250 Reputation points Microsoft External Staff Moderator