Environment
IDM 4.7.x upgrade to 4.7.2
Situation
postgres upgrade on
Linux fails: ‘lc_collate values for
database "postgres" do not match’.
When checking the log file
/var/opt/netiq/idm/log/pg-upgrade.log an error about an incorrect lc_collate
value is found e.g.: lc_collate values for database "postgres"
do not match: old "en_GB.UTF-8", new "en_US.UTF-8"
Resolution
Edit the upgrade script file e.g. Identity_Manager_4.7.2_Linux/common/scripts/pg-upgrade.sh and replace all instances of "en_US.UTF-8" with the correct database lc_collate value e.g. en_GB.UTF-8
Restore postgres and repeat the upgrade.