Azure database for PostgreSQL Single Server migrate of large database of 3 TB size

Wutiklai Chapanya 0 Reputation points
2023-11-15T03:45:53.78+00:00

I would like to migrate large database upto 3TB to new flexible server,

Problem 1: my existing database collocation "Thai" not support show output languages miss math mean "UFO Charecter cannot read"

Problem 2: During migration offine by migration feature on flexible server , effect database lock client session read/write

https://video2.skills-academy.com/en-us/azure/postgresql/migrate/concepts-single-to-flexible

Azure Database Migration service
Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-11-15T08:46:46.9533333+00:00

    Hi Wutiklai Chapanya,

    Welcome to Microsoft Q&A forum.

    As I understand, you are getting collation error in migration of Single to Flexible Server.

    We are sorry about the inconvenience.

    There is a similar Q&A post here:https://video2.skills-academy.com/en-us/answers/questions/1336701/collation-encoding-error-when-trying-to-migrate-fr?cid=kerryherger

    where the solution workaround is mentioned and recommended to raise support case for further assistance on the issue.

    Please take a look and let us know if you need any help.

    Thanks

    1 person found this answer helpful.
    0 comments