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

Question

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

Rajuvardhana K V 60

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 message in my 'Azure Database for single server' resource

Automatic migration is in progress

*This server is being migrated automatically to an Azure Database for PostgreSQL Flexible server of the same name and similar SKU. * How do I figure out the current status and know if the migration is infact in progress. It is only 150 GB database and should not have taken more than 4 hours as per speed benchmark.

User's image

Thank you

Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-03T06:09:29.8333333+00:00
Hi Rajuvardhana K V,

Greetings!

As I understand, your 'Azure Database for PostgreSQL single server' auto-migration to flexible server is stuck.

Ensure that the target Flexible Server has enough resources allocated to handle the migration.

Navigate to the Activity Log in the Azure portal. This log provides detailed information about all operations performed on your resources. Look for any entries related to the migration process.

Go to the Resource Health section of your PostgreSQL single server and flexible server resources. This can give you an idea if there are any ongoing issues affecting the migration.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.
Saraswathi Devadula 13,495 Reputation points Microsoft External Staff Moderator

2025-04-03T12:26:44.32+00:00

Hi Rajuvardhana K V,

Kindly please share the details requested in the private message for further investigation.

Thank you.
Rajuvardhana K V 60 Reputation points

2025-04-03T12:34:31.27+00:00

There is no target server created, no activity logs related to auto migration, and the resource health section is empty. However, the status still shows as "in progress." I would like to know if Azure will proceed with the auto migration since the deadline has already passed, or should we move forward with manual migration?
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-04T02:17:14.4166667+00:00

Hi Rajuvardhana K V,

Apologize for causing the issue.

I would like to know if Azure will proceed with the auto migration since the deadline has already passed, or should we move forward with manual migration?

Azure typically proceeds with auto migration if the deadline has passed, provided your servers meet the eligibility criteria and you haven't opted out. However, if there are specific complexities or configurations in your setup, manual migration might be necessary.

Reference Link: Migrate from Azure Database for PostgreSQL - Single Server to Flexible Server with the migration service.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-07T00:52:08.09+00:00

Hi Rajuvardhana K V,

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.
Rajuvardhana K V 60 Reputation points

2025-04-07T05:02:49.9066667+00:00

Hi @Mahesh Kurva

No resolution yet, i have filled the form to auto migrate but in portal it is still showing Migration is in progress.
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-07T05:45:35.7266667+00:00

Hi Rajuvardhana K V,

Could you please share the requested details in a private message so we can assist you further?

Thank you.
Rajuvardhana K V 60 Reputation points

2025-04-07T09:28:43.84+00:00

I have shared the requested details
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2025-04-08T17:00:39.1333333+00:00

@Rajuvardhana K V Thank you for reaching out.

I am sorry to hear about the issue you are facing with our service.

Scheduled auto migration is currently in Halted state; this seems to be a known issue in India South region where migration User fails to get cleaned up.

Our team is currently working on a fix.

However, there is a workaround to get this fixed. We can cancel the current schedule, will create a new schedule once you confirm the preferred schedule time.

Regards,

Oury
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2025-04-09T19:00:06.0266667+00:00

@Rajuvardhana K V Could you please confirm your preferred schedule.

Regards,

Oury
Rajuvardhana K V 60 Reputation points

2025-05-13T07:57:29.27+00:00

@Oury Ba-MSFT I have scheduled the automatic migration for the PostgreSQL server multiple times, but the migration has not been completed yet. The issue mentioned earlier has been resolved.

Do we need to wait for the auto-migration to complete, or are we allowed to proceed with the migration manually from our end?

Answer accepted by question author

0 additional answers

Your answer

Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-03T06:09:29.8333333+00:00

Hi Rajuvardhana K V,

Greetings!

As I understand, your 'Azure Database for PostgreSQL single server' auto-migration to flexible server is stuck.

Ensure that the target Flexible Server has enough resources allocated to handle the migration.

Navigate to the Activity Log in the Azure portal. This log provides detailed information about all operations performed on your resources. Look for any entries related to the migration process.

Go to the Resource Health section of your PostgreSQL single server and flexible server resources. This can give you an idea if there are any ongoing issues affecting the migration.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.
Saraswathi Devadula 13,495 Reputation points Microsoft External Staff Moderator

2025-04-03T12:26:44.32+00:00

Hi Rajuvardhana K V,

Kindly please share the details requested in the private message for further investigation.

Thank you.
Rajuvardhana K V 60 Reputation points

2025-04-03T12:34:31.27+00:00

There is no target server created, no activity logs related to auto migration, and the resource health section is empty. However, the status still shows as "in progress." I would like to know if Azure will proceed with the auto migration since the deadline has already passed, or should we move forward with manual migration?
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-04T02:17:14.4166667+00:00

Hi Rajuvardhana K V,

Apologize for causing the issue.

I would like to know if Azure will proceed with the auto migration since the deadline has already passed, or should we move forward with manual migration?

Azure typically proceeds with auto migration if the deadline has passed, provided your servers meet the eligibility criteria and you haven't opted out. However, if there are specific complexities or configurations in your setup, manual migration might be necessary.

Reference Link: Migrate from Azure Database for PostgreSQL - Single Server to Flexible Server with the migration service.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-07T00:52:08.09+00:00

Hi Rajuvardhana K V,

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.
Rajuvardhana K V 60 Reputation points

2025-04-07T05:02:49.9066667+00:00

Hi @Mahesh Kurva

No resolution yet, i have filled the form to auto migrate but in portal it is still showing Migration is in progress.
Mahesh Kurva 10,515 Reputation points Microsoft External Staff Moderator

2025-04-07T05:45:35.7266667+00:00

Hi Rajuvardhana K V,

Could you please share the requested details in a private message so we can assist you further?

Thank you.
Rajuvardhana K V 60 Reputation points

2025-04-07T09:28:43.84+00:00

I have shared the requested details
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2025-04-08T17:00:39.1333333+00:00

@Rajuvardhana K V Thank you for reaching out.

I am sorry to hear about the issue you are facing with our service.

Scheduled auto migration is currently in Halted state; this seems to be a known issue in India South region where migration User fails to get cleaned up.

Our team is currently working on a fix.

However, there is a workaround to get this fixed. We can cancel the current schedule, will create a new schedule once you confirm the preferred schedule time.

Regards,

Oury
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator

2025-04-09T19:00:06.0266667+00:00

@Rajuvardhana K V Could you please confirm your preferred schedule.

Regards,

Oury
Rajuvardhana K V 60 Reputation points

2025-05-13T07:57:29.27+00:00

@Oury Ba-MSFT I have scheduled the automatic migration for the PostgreSQL server multiple times, but the migration has not been completed yet. The issue mentioned earlier has been resolved.

Do we need to wait for the auto-migration to complete, or are we allowed to proceed with the migration manually from our end?

Answer 1

Hello Rajuvardhana K V

Azure Database for PostgreSQL - Single Server was officially retired on March 28, 2025 instances that missed migration deadlines have been disabled. Periodic notifications were sent since the announcement on March 28, 2023, at intervals of 2 years, 18 months, 15 months, 1 year, 6 months, 3 months, 1 month, and 1 week.

Notifications were sent via email to the subscription owner as well as with service health alert in the portal. Also, there was a notification on the portal page of Single Server as a popup acknowledgement for migration enablement.

I would like to inform you that, we have enabled the PostgreSQL single server for the next 30 days to migrate it to the Flexible Server, this is not extendable.

Use our migration service in Azure Database for PostgreSQL to simplify the migration experience. It provides both offline and online migration options. https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-single-to-flexible

Auto-migration option (offline mode only) can keep server name and DNS the same, so the application won’t need any connection string changes.

Note: Public Access needs to be enabled for the Single Server, and CMK server can’t be created using auto-migration.

Hope this helps. Do let us know if you 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.

Saraswathi Devadula 13,495 Reputation points Microsoft External Staff Moderator

2025-05-19T05:11:38.8666667+00:00

Hello Rajuvardhana K V

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. As this will help other community members in finding the correct answer easily.

Share via

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

0 additional answers

Your answer