I tried migrating from a single PostgreSQL Server to a flexible PostgreSQL Server via the Azure Migration Tool. I followed both of these articles to get everything setup.
https://learn.microsoft.com/en-us/azure/postgresql/migrate/concepts-single-to-flexible
https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-single-to-flexible-portal
However whenever i try to migrate after exactly 2 minutes and 3 Seconds i get the following error message:
Collation/Encoding not Supported Error: Failed to run ` SELECT a.table_schema, a.table_name, a.column_name, a.collation_name, cast(b.collnamespace AS text) AS collnamespace, cast(b.collowner AS text) AS collowner, b.collcollate, b.collctype, b.collencoding, pg_encoding_to_char(collencoding) AS encoding FROM information_schema.columns AS a INNER JOIN pg_collation AS b ON a.collation_name = b.collname AND b.collencoding = ( SELECT ENCODING FROM pg_database WHERE datname = '{0}') WHERE a.collation_name NOT IN ( SELECT DISTINCT ON (t1.collname, t2.collation_sche... (rest of the failure message is truncated.)
and the migration is cancelled. The error persists if i try using the cli or the portal. I also tried using it with a freshly created database which also doesn't work. The collations of my databases are the followings.
source
datname |
datcollate |
template1 |
English_United States.1252 |
template0 |
English_United States.1252 |
azure_maintenance |
English_United States.1252 |
azure_sys |
English_United States.1252 |
postgres |
English_United States.1252 |
destination
datname |
datcollate |
azure_maintenance |
en_US.utf8 |
template1 |
en_US.utf8 |
postgres |
en_US.utf8 |
template0 |
en_US.utf8 |
azure_sys |
en_US.utf8 |
Edit: Improved Readability of collations