We are having issues with some databases getting our locales generated. We are using Ubuntu 18.04 and postgresql 10.8.
Example: *from bash prompt:* $ locale -a | egrep fr fr_BE fr_BE@euro fr_BE.iso88591 fr_BE.iso885915@euro fr_BE.utf8 fr_CA fr_CA.iso88591 fr_CA.utf8 fr_CH fr_CH.iso88591 fr_CH.utf8 french fr_FR fr_FR@euro fr_FR.iso88591 fr_FR.iso885915@euro fr_FR.utf8 fr_LU fr_LU@euro fr_LU.iso88591 fr_LU.iso885915@euro fr_LU.utf8 *from psql prompt:* [local] cnemelka@postgres=# create collation french (provider=libc,locale='fr_FR.utf8'); ERROR: 22023: could not create locale "fr_FR.utf8": No such file or directory DETAIL: The operating system could not find any locale data for the locale name "fr_FR.utf8". LOCATION: report_newlocale_failure, pg_locale.c:1312 *Anyone having similar issues or know of the solution?* *TIA,* --cnemelka
