Migration from Postgresql Single Server to Flexible stuck

Szwed, Slawomir 0

Hi,

I triggered migration from single server to flexible server (7 databases). 5 were migrated successfully but it stuck on 6. For last 3h I'm having "Migration data" and when I click on details I can see this:

Is there any way to check what migration is doing? Is it stuck or migrating something?

Mallaiah Sangi 85 Reputation points Microsoft Vendor

2025-02-27T21:24:02.46+00:00

Hi @Szwed, Slawomir

Thanks for the Question and using Microsoft Q&A

As per my understanding, you are facing an issue in Postgresql Single Server to Flexible database migration.

Monitor the migration portal

After you start the migration, a notification appears to say that the validation or migration creation is successful. You're redirected automatically to the Migration page of Flexible Server. This has a new entry for the recently created validation or migration.

The grid that displays the migrations has these columns: Name, Status, Migration mode, Migration type, Source server, Source server type, Databases, Start time and Duration. The entries are displayed in the descending order of the start time with the most recent entry on the top.

You can use the Refresh button to refresh the status of the validation or migration.

You can also select the name of one particular migration in the grid to see the associated details.

When the validation or migration is created, it moves to the InProgress state and PerformingPreRequisiteSteps substate. The workflow takes 2-3 minutes to set up the migration infrastructure and network connections.

Let us look at how to monitor migrations for each migration option.

Please find the Migration documentation guide link: https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-single-to-flexible?tabs=portal%2Coffline

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

Share via

Migration from Postgresql Single Server to Flexible stuck

Your answer