IDM 472 Postgres upgrade fails

  • 7023673
  • 25-Jan-2019
  • 07-Feb-2019

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.