In Windows 10 Fall Creators Update (version 1709 and newer), Microsoft changed the Czech region name from Czech Republic to Czechia. Due to this change, PostgreSQL might fail to start with following error:

2017-10-20 14:34:52 CEST LOG:  invalid value for parameter "lc_monetary": "Czech_Czech Republic.1250"
2017-10-20 14:34:52 CEST LOG:  invalid value for parameter "lc_numeric": "Czech_Czech Republic.1250"
2017-10-20 14:34:52 CEST LOG:  invalid value for parameter "lc_time": "Czech_Czech Republic.1250"

 

The solution is to download Locale Builder 2.0 from Microsoft and create modified locale:

  1. Create new locale based on Czech locale (cs-CZ), do not change the locale name (cs-CZ)
  2. Changed region name to "Czech Republic" (from "Czechia")
  3. Create installer by selecting "Build" -> "Build Locale Installer" in top menu.
  4. Once the file is built, install it by double-clicking it and following the instructions.
  5. Restart the PostgreSQL server or (and) BellaDati service.

 

  • No labels