PostgreSQL Flexible Server Not Appearing After Automatic Migration

NGUYEN HUNG CUONG 20

Hello,

My Azure Database for PostgreSQL Single Server was scheduled for migration to an Azure Database for PostgreSQL Flexible Server on August 31, 2024. However, the old PostgreSQL Single Server has now been deleted, and I am unable to locate the new Flexible Server in any of my resources. I’ve also checked via the Azure CLI, but the list is empty. Despite this, my services are still running and connected to the database.

I have not received any information or notification about this unusual situation. Is this expected behavior? What steps should I take next?

I found a similar issue that was resolved here:
https://learn.microsoft.com/en-us/answers/questions/2068006/my-postgresql-single-server-disappeared-after-auto

Could you please investigate and help resolve my issue as well?

Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-18T09:40:14.73+00:00

Hi @NGUYEN HUNG CUONG,

Thanks for the question and using MS Q&A platform.

I agree that this issue looks strange, and I wasn't able to reproduce this issue. If you have a support plan, could you, please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan, please let us know here.
NGUYEN HUNG CUONG 20 Reputation points

2024-09-18T09:59:00.39+00:00

Hi @Sai Raghunadh M

Thank you for your response. I don't have a support plan yet. Please let me know how we can proceed.
NGUYEN HUNG CUONG 20 Reputation points

2024-09-19T03:03:16.45+00:00

Hi @Sai Raghunadh M

I received a notification about a private message, but when I click on "View messages," the loading spinner keeps going indefinitely. Additionally, nothing happens when I try to send a private message. Is there an issue?
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-19T18:42:53.0466667+00:00

Hi @NGUYEN HUNG CUONG,

Even now are you facing the same issue?
NGUYEN HUNG CUONG 20 Reputation points

2024-09-20T00:09:53.1166667+00:00

yes, @Sai Raghunadh M The situation hasn’t changed
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-25T01:48:59.7566667+00:00

Hi @NGUYEN HUNG CUONG,"We have sent a private message again; could you please check it?"
NGUYEN HUNG CUONG 20 Reputation points

2024-09-25T02:28:35.68+00:00

Hi @Sai Raghunadh M
Unfortunately, I'm still unable to check the private message, as I reported this issue about a week ago. The loading spinner continues indefinitely, and I cannot send or view private messages. This is significantly affecting our business, so I would greatly appreciate your prompt assistance in resolving this issue. Thank you.
NGUYEN HUNG CUONG 20 Reputation points

2024-09-25T02:36:38.8933333+00:00

Please check the private messages windows as the attach file.
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-27T07:11:27.1033333+00:00

Hi @NGUYEN HUNG CUONG,

Could you please check if the missed PostgreSQL Flexible Server is visible?
NGUYEN HUNG CUONG 20 Reputation points

2024-09-27T11:48:23.66+00:00

Hi @Sai Raghunadh M

I still cannot see PostgreSQL Flexible Server in either ‘All Resources’ or on the ‘Azure Database for PostgreSQL Flexible Server’ page.
Oury Ba-MSFT 19,831 Reputation points Microsoft Employee

2024-09-27T17:36:04.3666667+00:00

@NGUYEN HUNG CUONG

Please send an email to azcommunity@microsoft.com with your subscription Id, server name and region please. Please mention in the subject line ATTN: Oury so I don't miss it.

Regards,

Oury
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-30T09:24:54.12+00:00

Hi @NGUYEN HUNG CUONG,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
NGUYEN HUNG CUONG 20 Reputation points

2024-09-30T13:25:34.4633333+00:00

Hi @Sai Raghunadh M

I have sent an email to azcommunity@microsoft.com with the required information for further investigation. I hope the issue will be resolved soon.
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-09-30T15:48:06.23+00:00

Hi @NGUYEN HUNG CUONG,

Thanks for the confirmation.
NGUYEN HUNG CUONG 20 Reputation points

2024-10-02T14:08:39.7066667+00:00

Hi @Oury Ba-MSFT

I've sent an email to azcommunity@microsoft.com following your suggestion. Could you kindly check it?

The subject of the email is: [ATTN: Oury] PostgreSQL Flexible Server Not Appearing After Automatic Migration.
NGUYEN HUNG CUONG 20 Reputation points

2024-10-07T11:38:08.68+00:00

Hi @Sai Raghunadh M

I sent an email to azcommunity@microsoft.com as suggested, but I received the following response:
"Currently this DL is in unmonitored state and would request you open a new thread on Q&A platform for your query/issue with appropriate service area tag so that one of the community experts will reach you shortly for further assistance – Microsoft Q&A platform – Ask a question For more details, refer to Ask a question on Microsoft Q&A"

What should I do next to get further assistance?
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-10-15T15:50:12.2166667+00:00

Hi @NGUYEN HUNG CUONG,

We have sent an email. Have you submitted a support ticket? Was your issue resolved?
NGUYEN HUNG CUONG 0 Reputation points

2024-10-16T03:17:28.5766667+00:00

Hi @Sai Raghunadh M

Thank you for your follow-up. The issue has been resolved, and no further assistance is required.
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-10-16T17:21:45.3733333+00:00

Hi @NGUYEN HUNG CUONG,

Glad to know that your issue has been resolved. Could you please share the resolution here, which might be beneficial to other community members reading this thread.
NGUYEN HUNG CUONG 0 Reputation points

2024-10-18T03:33:26.4866667+00:00

Hi @Sai Raghunadh M

I would like to share the solution as I received from Supporter as below:
Resolution:

As per the case verbatim, you were not able see the Azure Database for PostgreSQL flexible server after migration from single server to flexible server.

After migration Azure database for flexible servers are running at backend but unfortunately not showing in portal. After migrating from Azure Database for MySQL Single Server to Flexible Server, an ARM (Azure Resource Manager) refresh is required due to the way Azure manages and updates its resources. When the migration is completed, the ARM cache needs to be refreshed to reflect the new state of the resources. This refresh ensures that the Azure Portal and other management tools display the most up-to-date information about the migrated resources.
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-10-18T16:22:02.2933333+00:00

Hi @NGUYEN HUNG CUONG,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

1 answer

Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-10-18T16:20:21.1266667+00:00

Hi @NGUYEN HUNG CUONG,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Issue:

My Azure Database for PostgreSQL Single Server was scheduled for migration to an Azure Database for PostgreSQL Flexible Server on August 31, 2024. However, the old PostgreSQL Single Server has now been deleted, and I am unable to locate the new Flexible Server in any of my resources. I’ve also checked via the Azure CLI, but the list is empty. Despite this, my services are still running and connected to the database.

I have not received any information or notification about this unusual situation. Is this expected behavior? What steps should I take next?

I found a similar issue that was resolved here: https://learn.microsoft.com/en-us/answers/questions/2068006/my-postgresql-single-server-disappeared-after-auto

Could you please investigate and help resolve my issue as well?

Solution:

As per the case verbatim, you were not able see the Azure Database for PostgreSQL flexible server after migration from single server to flexible server.

After migration Azure database for flexible servers are running at backend but unfortunately not showing in portal. After migrating from Azure Database for MySQL Single Server to Flexible Server, an ARM (Azure Resource Manager) refresh is required due to the way Azure manages and updates its resources. When the migration is completed, the ARM cache needs to be refreshed to reflect the new state of the resources. This refresh ensures that the Azure Portal and other management tools display the most up-to-date information about the migrated resources.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.

1 person found this answer helpful.
Sai Raghunadh M 1,605 Reputation points Microsoft Vendor

2024-10-21T17:35:43.7966667+00:00

Hi @NGUYEN HUNG CUONG,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others".

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

PostgreSQL Flexible Server Not Appearing After Automatic Migration

1 answer

Your answer