I am going to upgrade PostgreSQL server from "Single Server" to "Flexible Server"(version 13) due to some business requirements. According to the Azure's doc, the Flexible Server uses " en_US.utf8" while the Single Server does "English_United States.1252". How does this affect? The Postgres doc says "The LC_COLLATE and LC_CTYPE variables affect the sort order of indexes". If this is the case, I need to rebuild the indexes. I am wondering what else needs to be done for successful migration. I appreciate any advice on this. Thanks.
I would like to know what would be the standard procedure when the locale setting is changed.
Thanks to @Sampath @Masakorelab, Posting it as Answer
According to the Azure documentation, the Flexible Server uses “en_US.utf8” while the Single Server does "English_United States.1252"2. The Postgres documentation states that "The LC_COLLATE and LC_CTYPE variables affect the sort order of indexes"1. Therefore, you may need to rebuild the indexes.
In addition, you may need to perform a dry run of the in-place major version upgrade in a non-production environment before upgrading the production server. This allows you to identify any application incompatibilities and validate that the upgrade completes successfully before upgrading the production environment. You can perform a Point-In-Time Recovery (PITR) of your production server and test the upgrade in the non-production environment. Addressing these issues before the production upgrade minimizes downtime and ensures a smooth upgrade process