Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,240 questions
Azure scheduled auto migration from postgresql single server to flexible server is stuck 'in progress' status for 23 hours
![](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(64, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jayabharathi Nagaraj
0
Reputation points
Hello,
I had a scheduled auto migration from Postgresql single server to flexible server. It has been stuck 'In Progress' status for last 23 hours. 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 250 GB database and should not have taken more than 4 hours as per speed benchmark.
Thank you
{count} votes
-
![](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(249.60000000000002, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Adithya Prasad K 10 Reputation points Microsoft External Staff2025-03-07T13:27:53.01+00:00 Hi Jayabharathi Nagaraj,
Thank you for reaching out and posting the query.
Could you please assist us in understanding how you are migrating —whether it's through dump and restore or using Azure DMS? -
Jayabharathi Nagaraj 0 Reputation points
2025-03-07T13:52:06.8966667+00:00 Hello Adithya Prasad,
Thank you for your reply.
I simply scheduled the timing for auto migration process in the gui under my PostgresSQL single server resource page. Please find the attached image that shows the status change.Also, I did not create a new flexible server as the migration header stated that a new server of similar name and SKU will be generated during the migration process
-
![](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(185.6, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Dileep Raj Narayan Thumula (MINDTREE LIMITED) 0 Reputation points Microsoft External Staff2025-03-07T17:09:57.67+00:00 Hello @Jayabharathi Nagaraj ,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
Regarding your question:
Azure scheduled auto migration from PostgreSQL single server to flexible server is stuck 'in progress' status for 23 hours
For instance, if your migration started on March 7, 2025, it should be finished by March 14, 2025.
That is because migrating from Azure Database for PostgreSQL Single Server to Flexible Server usually takes no more than seven days (168 hours).
If it is taking longer, you should check the migration status in the Azure portal or reach out to Azure support for help.
You can find more details here:
I hope this is helpful! Do not hesitate to let me know if you have any other questions.
Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful
Sign in to comment
Sign in to answer