Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,046 questions
Cannot find Azure DB for PostgreSQL after auto migration
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Brandon Rush
0
Reputation points
Azure recently auto migrated my PostgreSQL single server to the new flexible server. I had been waiting for the migration to finish (which ended up taking far longer than they said), and today when I logged into the portal to check the status, I can no longer see my database. I know that the database still exists because my other resources that access it are working fine, but I have no way to actually see the resource in the portal now. In the documentation it says that the new flexible server will be placed in the same resource group as the old single server, but that does not seem to be the case. Does anyone know how I can find the database?
{count} votes
-
Oury Ba-MSFT 18,866 Reputation points Microsoft Employee2024-09-24T17:51:48.8233333+00:00 @Brandon Rush Thank you for reaching out.
Could you please check if the db is not residing in a different resource group.
You can also use the Azure CLI to list all PostgreSQL flexible servers in your subscription by running the following command:
az postgres flexible-server db list --resource-group --server-name
If you are not able to see the db name after running the below command. I would suggest creating a support ticket so we can further investigate this issue.
Regards,
Oury
-
Brandon Rush 0 Reputation points
2024-09-24T18:54:25.4566667+00:00 @Oury Ba-MSFT Thanks for the response. I can confirm that the db is not in a different resource group. I used the Azure CLI command that you mentioned, and it does not recognize the server name.
When I use the
az resource listcommand to list all resources, it does not show up either.
I can see in my activity log where I got multiple messages stating that the migration was completed and that my new flexible server would be named the same, in the same resource group, and have the same connection strings as the old single server. So I know that the server exists, I just cannot get it to show up for some reason.
If I open a ticket, do I have to purchase a support plan other than the Basic one? I would hate to have to spend $30 to open a ticket for an issue that clearly seems to be an Azure problem...
-
Oury Ba-MSFT 18,866 Reputation points Microsoft Employee
2024-09-25T22:50:54.7733333+00:00 You should be able to create a support ticket with support plan. https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request
Please let me know if you faced any issues. I will help you further on this.
Please in the meantime try to read this doc regarding auto-migration from single to flexible on Azure PostgreSQL servers.
Regards,
Oury
Sign in to comment
Sign in to answer