1,328 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

Unable to migrate Postgres Single Server

Azure Postgres Single Server has been disabled automatically. The message in the resource page displays "The last migration attempt didn't work or was cancelled. We'll reschedule the automatic migration soon." When I try to manually start the…

Azure Database for PostgreSQL
asked 2025-05-10T02:51:16.02+00:00
Rakshak Shrestha 0 Reputation points
0 answers

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
commented 2025-05-10T00:26:56.8066667+00:00
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator
1 answer

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 0 Reputation points
answered 2025-05-10T00:13:18.4933333+00:00
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator
0 answers

PostgreSQL single server migration to PostgreSQL flexible server fails due to error

On 02.05.2025 our PostgreSQL single server instance stopped working (our assumption it was disabled due to scheduled retirement of PostgreSQL single server service). It is no longer possible to connect to DB using PostgreSQL clients. We created…

Azure Database for PostgreSQL
asked 2025-05-07T09:52:40.9466667+00:00
Apply IT 0 Reputation points
commented 2025-05-09T19:54:55.37+00:00
Sai Raghunadh M 3,480 Reputation points Microsoft External Staff Moderator
1 answer

Azure Postgres Single Server is disabled due to forced migration

Azure Postgres Single Server is disabled and I am unable to access it. The Portal itself has conveyed the following message: The last migration attempt didn't work or was cancelled. We'll reschedule the automatic migration soon. We were awaiting the…

Azure Database for PostgreSQL
asked 2025-05-08T10:09:09.5933333+00:00
Prathamesh Joshi 0 Reputation points
answered 2025-05-09T13:04:24.5266667+00:00
Sai Raghunadh M 3,480 Reputation points Microsoft External Staff Moderator
0 answers

Azure Postgres Flexible server - custom read replication

Greetings, I have a need to create a custom read replication for my Azure Postgres Flexible server instance. It is currently not deployed as High-Availability, but it can be promoted. I am mentioning HA because I've read in a few places read-replication…

Azure Database for PostgreSQL
asked 2025-05-09T11:23:13.1133333+00:00
Nemanja Simpraga 0 Reputation points
commented 2025-05-09T12:40:21.4833333+00:00
Sai Raghunadh M 3,480 Reputation points Microsoft External Staff Moderator
0 answers

Postgresql flexible server impossible to delete after failed creation

Hello everyone, I have an issue on Azure. I created with the CLI a postgresql flexible server, but this creation failed with internal error: (InternalServerError) An unexpected error occured while processing the request. Tracking ID:…

Azure Database for PostgreSQL
asked 2025-05-07T09:49:51.8466667+00:00
Joshua 0 Reputation points
commented 2025-05-09T12:03:25.3066667+00:00
Adithya Prasad K 840 Reputation points Microsoft External Staff Moderator
1 answer

Postgres Flexible server outage in swedencentral, cannot connect, stop or start, affecting production

Hello, Our production Azure Database for PostgreSQL flexible server instance on swedencentral went down, all Azure says that its "Unexpected issue" and that I should contact support. Our production applications are down because of the…

Azure Database for PostgreSQL
asked 2025-04-11T04:21:12.69+00:00
Otto Laitila 5 Reputation points
commented 2025-05-09T11:48:55.3666667+00:00
Mahesh Kurva 3,830 Reputation points Microsoft External Staff Moderator
1 answer

Auto migration of Azure Database for PostgreSQL Single server did not happen, and it is now disabled.

I made a mistake. I allowed Azure Database for PostgreSQL Single server to go on beyond the end date. It still shows in my resources, but is now Disabled, and attempts to connect or migrate are not working. The automigration from Azure was supposed to…

Azure Database for PostgreSQL
asked 2025-05-08T15:20:14.33+00:00
Garland, Scott 0 Reputation points
edited a comment 2025-05-09T09:29:32.2+00:00
Vijayalaxmi Kattimani 2,235 Reputation points Microsoft External Staff Moderator
0 answers

Internal server error when trying to restore Deleted PostgreSQL server

Good day sir/ma,    I'm having issues recovering my deleted postgresql server, after following all the steps in your documentation below:  https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restore-dropped-server   And I keep…

Azure Database for PostgreSQL
asked 2025-05-06T09:15:32.81+00:00
Nnaemeka Atueyi 0 Reputation points
edited a comment 2025-05-09T05:33:41.3933333+00:00
Narendra Pakkirigari 0 Reputation points Microsoft External Staff Moderator
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-05-08T19:38:13.1166667+00:00
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator
0 answers

Failed automatic Database Migration from Azure Postgres Single server to Flexible

We've missed the cutoff for migrating one of our instances from Azure Postgres Single Server to Flexible server, and now my instance is showing a Disabled state in the portal. I have tried to initiate the migration manually but I am unable since the…

Azure Database for PostgreSQL
asked 2025-05-08T14:55:39.4333333+00:00
Nico Zarb 5 Reputation points
commented 2025-05-08T15:15:02.7866667+00:00
Vijayalaxmi Kattimani 2,235 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

PostgreSQL flexible server stuck in 'Starting' state

My PostegreSQL server was having issues where it was 100% CPU usage and not accepting connections. I have shut it down and booted it back up in the hopes to restore it but now it is stuck with this message for the last 3 days: The server is currently in…

Azure Database for PostgreSQL
asked 2025-05-07T05:44:58.5266667+00:00
Adam Rybak 20 Reputation points
accepted 2025-05-08T08:18:43.9133333+00:00
Adam Rybak 20 Reputation points
1 answer

I need to install pg_partman v5.2.4

Hello, I need to install pg_partman v5.2.4 in my Postgres database. This link has a step-by-step guide https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pg-partman , but it doesn't provide a way to define the pg_partman…

Azure Database for PostgreSQL
asked 2025-05-02T15:16:05.4133333+00:00
Leandro Silva - KMM 0 Reputation points
commented 2025-05-07T21:26:41.9366667+00:00
Leandro Silva - KMM 0 Reputation points
2 answers

Cannot create azure postgres flexible servers in germany westcentral

Hello, I cannot create an azure postgress flexible server in germany westcentral. I have all permissions and I don't see any restriction under usage/quota. Also policy list in my subscription is empty

Azure Database for PostgreSQL
asked 2025-05-02T09:10:42.25+00:00
Duc 0 Reputation points
commented 2025-05-07T17:40:15.4666667+00:00
Duc 0 Reputation points
1 answer

Azure Postgres Single Server is disabled due to forced migration - need to export/dump data one last time to capture a final snapshot

Azure Postgres Single Server is disabled due to forced migration - need to export/dump data one last time to capture a final snapshot. Now that database has been auto-disabled, i still need a way to export data one last time. this should be built in…

Azure Database for PostgreSQL
asked 2025-05-05T14:03:31.4733333+00:00
Robert Boudreau 0 Reputation points
answered 2025-05-06T16:39:05.96+00:00
PratikLad 965 Reputation points Microsoft External Staff Moderator
3 answers

How to use pg_cron extension in multiple databases in azure flexible postgres Server

Hi team, I have enabled pg_cron extension by making changes in server parameters. Enabling pg_cron in azure.extenssion and shared_preload_libraries. We have multiple databases in our cluster. I need to configure jobs in all the DBs using…

Azure Database for PostgreSQL
asked 2022-10-25T17:11:55.49+00:00
Mani Mahesh Sivakumar 56 Reputation points
commented 2025-05-06T15:36:28.4266667+00:00
Alex Dragan 1 Reputation point
1 answer

Is there a way to reconfigure the server after selecting an unsupported region, or do I need to start over in a supported region?

I attempted to set up a PostgreSQL Flexible Server in the East US region but encountered deployment errors because PostgreSQL Flexible Servers are not fully supported in that region. Can Azure provide better feedback or warnings during the region…

Azure Database for PostgreSQL
asked 2025-04-28T00:58:55.44+00:00
Moderne Edge 0 Reputation points
commented 2025-05-02T04:05:54.0366667+00:00
Prasad Chaganti 645 Reputation points Microsoft External Staff Moderator
1 answer

BUG: Orphaned roles cannot be dropped on Azure DB for PostgreSQL v16

With Azure Database for PostgreSQL Flexible Server V16 it is not possible to drop orphaned roles with the cloud provider admin account azure_pg_admin. Only actual DB superusers can manage orphaned roles in PG V16. The community is aware of the problem…

Azure Database for PostgreSQL
asked 2025-04-18T06:34:47.33+00:00
Thuerriedl, Reinhard 20 Reputation points
answered 2025-04-30T13:13:22.9466667+00:00
PratikLad 965 Reputation points Microsoft External Staff Moderator
1 answer

Unable to provision PostgreSQL Flexible Server in 'South Central US' using Microsoft Azure Sponsorship (Founders Hub)

I'm trying to provision a new PostgreSQL Flexible Server in the South Central US region using my Microsoft Azure Sponsorship subscription (via Microsoft for Startups Founders Hub), but I'm getting the following error: "Subscription 'Microsoft Azure…

Azure Database for PostgreSQL
asked 2025-04-26T09:17:51.32+00:00
Mahdi Barkhordari 0 Reputation points
commented 2025-04-29T23:37:38.8033333+00:00
Manasa Akula 435 Reputation points Microsoft External Staff Moderator