Migration from Postgresql Single Server to Flexible stuck

Question

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 1,145 Reputation points Microsoft External Staff Moderator

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
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-28T21:13:44.75+00:00

Hi @Szwed, Slawomir

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.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-03T05:51:03.9733333+00:00

Hi @Szwed, Slawomir

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.
Szwed, Slawomir 0 Reputation points

2025-03-03T08:13:08.18+00:00

Let me explain my issue one more time. I triggered migration from Single server to Flexible. So my problem is that migration stuck in "In progress" mode. When I opened detailed page I saw that all tables were migrated. So my question is: how I can migrate it. I don't know what is happening in the background. I also request to perform auto-migration from MS team but no response so far. I've read all guides how to do migration. I did 2 migrations successfully so far. But this time it stuck and I don't know why.

1 answer

Your answer

Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

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
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-02-28T21:13:44.75+00:00

Hi @Szwed, Slawomir

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.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-03T05:51:03.9733333+00:00

Hi @Szwed, Slawomir

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.
Szwed, Slawomir 0 Reputation points

2025-03-03T08:13:08.18+00:00

Let me explain my issue one more time. I triggered migration from Single server to Flexible. So my problem is that migration stuck in "In progress" mode. When I opened detailed page I saw that all tables were migrated. So my question is: how I can migrate it. I don't know what is happening in the background. I also request to perform auto-migration from MS team but no response so far. I've read all guides how to do migration. I did 2 migrations successfully so far. But this time it stuck and I don't know why.

Answer 1

Let me explain my issue one more time. I triggered migration from Single server to Flexible. So my problem is that migration stuck in "In progress" mode. When I opened detailed page I saw that all tables were migrated. So my question is: how I can migrate it. I don't know what is happening in the background. I also request to perform auto-migration from MS team but no response so far. I've read all guides how to do migration. I did 2 migrations successfully so far. But this time it stuck and I don't know why.

Share via

Migration from Postgresql Single Server to Flexible stuck

1 answer

Your answer