Missed automatic migration of PostgreSQL Database from Single Server and now it is disabled

Question

I didn’t act in time to manually trigger the migration - a mistake. The automatic migration from Azure Database for PostgreSQL – Single Server to Flexible Server did not happen as expected. I also missed the window to manually migrate it.

Now the server shows as "Disabled" and I can not access the data or trigger any migration. Recovery, access, and migration attempts have i tried and all failed.

Is there any way to temporarily restore access or recover the data?

Any help or ideas would be greatly appreciated.

Thanks,

Answer 1

Hi Sauter, Robin

PostgreSQL Database from Single Server and now it is Enable, could you please verify and confirm from your end.

I hope this has been helpful!

Your feedback is important so please take a moment to accept answers. If you still have questions, please let us know what is needed in the comments so the question can be answered. Thank you for helping to improve Microsoft Q&A!

If this answers your query, do click Accept Answer and Upvote for was this answer helpful.

Answer 2

The reactivation helped. I was able to create a dump of the current database and migrate it to a new server. Everything is working again now. The automatic migration wasn't possible due to the TimescaleDB service, but that wasn't a problem — the standard dump worked fine.

Thanks!